Hello,

I would like to make multiple if statements in a field calculation that reference other fields in the table.

How can I make the calculation for example: if a field is equal to another field, the designated value is a certain formula, if a field is another diferent formula then its value is another formula. So on and so forth.

The following picture shows, what i have so far, but it's not working if I want to add more if statements.Can you please give me some advise on how to write my calculation.

Any help is appreciated. Thank you.

Jose

You can either use the Case() function or possibly even the Let() function.

EG:

Case (

condition1 ; result1;

condition2 ; result2;

elseresult

)

That let's you chain multiple "if" statements together. Case() evaluates until it reaches a "true" condition, then returns that result. If no condition is met, then the "else" result is returned.

So you could do something like:

Case (

Customers::Distr_Type = "SA-1" and Water_used_cf > 105000 ; (Water_used_cf - 105000) * .0151 ;

Customers::Distr_Type = "SA-1" and Water_used_cf > 100000 ; Water_used_cf - 100000 ;

etc...

)