1 2 Previous Next 16 Replies Latest reply on Aug 27, 2018 6:17 PM by bhargavi chittibomma

    Exclude dimension dynamically using calculated field

    bhargavi chittibomma

      Hi All,

       

      Need some help in dynamically excluding the  dimension value

       

      if [Revenue Month]= "2018" and [Ebit Tree Level 3]="CardHolderMonthlyFees" and

      [Business Calssification Category]="Prepaid Open Loop" then [Revn Amt]

      ELSEIF [Revenue Month]> "2018" and [Ebit Tree Level 3]="CardHolderMonthlyFees"  or [Ebit Tree Level 3]="Pin Fees" or

      [Ebit Tree Level 3]= "Signature Fees" and

      [Business Calssification Category]="Prepaid Open Loop" then [Revn Amt]

      else null end

       

      not sure what I did wrong here...

       

      All I need is.. in 2018 I have to consider only "cardholdermonthlyfees" and in 2019 i have to include all  "cardholdermonthlyfees","Signature Fees","Pin Fees"  thats the logic I am trying to implement here..

       

       

      Any immediate help on this would be appreciated

       

      Thanks

      Bhargavi

        1 2 Previous Next