6 Replies Latest reply on Jan 14, 2019 8:52 AM by Olajumoke Adetunji

    Aggregate & non Aggregate issues

    Olajumoke Adetunji

      I am trying to use this calculated field but I am getting errors.

       

      Something like this :

      If Year[ReportDate] = 2017 Then [Sales_Calc] End

       

      Sales_Calc is a calculated field.

      Sum[SalesA] / Sum[SalesB] * 1000000

       

      Note: I do not want to use the reportDate filter for 2017 because there are other measures in the same sheet that requires the Date filter to be set to 2017 & 2018. So this has to be done in a way that where the data is only pulled for 2017 regardless of the filter.

       

      Any help will be greatly appreciated.