formula

I need to create a formula that says if \$number_base_stations_c is greater than 1 multiply \$number_base_stations_c x \$990.  Otherwise the field should be \$0.  I can't seem to get this formula to work.  Would love help on this one.

Parents
• I expect that you have the value of the computed value in a separate field? What have you tried so far? In any case. You need an extra field that does something like this:

ifElse(greaterThan(\$testfield_c,1),multiply(\$testfield_c,99),0)

• Thanks so much for the help.  I actually missed one piece to add.  This works but I only want it to do the math for the stations above 1.  So if they have 1 station the answer would be \$0.  If they have 2 stations the answer would be \$990, 3 stations would be \$\$1,980.  Not sure if that makes sense?

Hi, I figured out a workaround,   Thanks for your help.

• Ah, actually its easy. In the formula you need to substract 1 from the value in 'testfield_c' before you multiply.

so the formula would be something like:

ifElse(greaterThan(\$testfield_c,1),multiply(subtract(\$testfield_c,1),99),0)

in this case if the testfield = 1 it returns 0

in any other case the 'station' has 1 substracted and multiplied with 99.