Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello together,
i have a Problem with two Formulas, how can I combinate the two following Formulas:
1.
if (Währung <> 'EUR', EffektwertSumme*Kurs)
2.
SUM(IF(Kreditorabkürzung = '3', 0, [EffektivwertSumme]))
Do you have any solution, how I can combinate this to formulas.
Thank you.
Greets
Nikolaus80
Depends what outcome you want, you've not provided enough informaton. However as an exmaple you could do the following:
SUM(IF(Kreditorabkürzung = '3' ,0, if(Währung <> 'EUR' ,EffektwertSumme*Kurs,EffektwertSumme)))
Depends what outcome you want, you've not provided enough informaton. However as an exmaple you could do the following:
SUM(IF(Kreditorabkürzung = '3' ,0, if(Währung <> 'EUR' ,EffektwertSumme*Kurs,EffektwertSumme)))