11 Replies Latest reply: Oct 8, 2015 12:53 AM by Avinash R RSS

    Set Analysis in Calculation (Multiplication)

    Christian Wylezol

      Hi,

       

      I have a (for me) very tough Topic.

      I want to calculate something but I dont get it to work. Maybe someone of you can help me

       

      Now the Formular:

       

      =TaxRate*[Act Year IFRSADJ]
      (The  Calculation works but it calculate all entries, - even the ones with DefTaxCode = 'N/A')

       

      Wish:

      =TaxRate*[Act Year IFRSADJ] (ONLY If DefTaxCode <> 'N/A')

       

       

      Thanks in advance.

      Chris