1 Reply Latest reply on Feb 9, 2018 10:02 PM by Esther Aller

    Display a dimension1 when ATTR(dimension2) is not * (multiple) in blending

    Ahmed Mukhtar

      There are two fields, currency and revenue.

       

      I am having blending of the data sources and when the currency for the same row is multiple currency shows *

       

      When it shows * (that is the currency is multiple) , I dont want to show the revenue field. other wise, if the ATTR currency is unique (not *), I want to display the revenue

       

      I am using

       

      IF MIN ([Currency Measure]) = MAX ([Currency Measure])

      THEN 0

      ELSE [Total Revenue (Local)]

      END

       

      It shows the error of cannot mix aggregate and not aggregate in the if statement.

       

      How can i accomplish