calculation Calculation with multiple options in portal

[Quant]

Hello,

Could someone help me with this question?

I have a row in a portal in wich i would like to make a calculation: Bedrag= Cases*Prijs,  but if Hoeveelheid is filled in then it should calculate Bedrag= Hoeveelheid*Prijs.
The fields are all numeric. The calculation should be possible on one row, in this example i have made it on two.

Yours sincerely

Frans

 

[doughemi]

Try:

Case(
Hoeveelheid > 0; Hoeveelheid*Prijs;
Cases*Prijs
)

(Note that the calculation is on separate lines for clarity. FileMaker doesn't particularly care about line breaks.) Read about the Case statement here.

Edited February 4, 2018 by doughemi
correct calculation

[Quant]

3 hours ago, doughemi said:

Try:

Case(
Hoeveelheid > 0; Hoeveelheid*Prijs;
Bedrag= Cases*Prijs
)

(Note that the calculation is on separate lines for clarity. FileMaker doesn't particularly care about line breaks.) Read about the Case statement here.

Hi doughemi,

Thanx for your reply,  the calculation  Bedrag=Cases*Prijs is not working, but when i do  Cases*Prijs  it works ok.

Thank you for support!!

[doughemi]

Cut and paste at 1:00 AM does that to a guy. Sorry! Glad you figured it out.