Set Analysis in Calculation (Multiplication)

[#1]

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

[nagaiank]

Did you try the following:

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

[avinashelite]

Hi Christian,

Can you please share your app ??