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)]



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


      How can i accomplish