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


      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!



        1 2 Previous Next