1 2 Previous Next 16 Replies Latest reply on Oct 12, 2018 10:46 AM by ariya.hemati

    Non Aggregation and Aggregation Error in If Statement

    ariya.hemati

      I'm sure this is simple, but I've been running into issues all day.

       

      I want to write a formula where:          If [Transaction Type]="Buy" then [Avg Balance] Else 0 END          Basically, I want to bring the Avg Balance for all my 'buys'.

       

      Transaction Type is a Dimension with the following values:  Null, Buy, Sell   and   Average Balance is calculated field.

       

      Any help would be appreciated!

       

      Thanks

        1 2 Previous Next