Multiple result by a factor
-
Hi guys,
Wondering how to multiply the result of my formula by a factor, for example I have this kind of formula (just the example from your FAQ):
(function(){ if(fieldname3 > 100) return fieldname1+fieldname2; if(fieldname3 <= 100) return fieldname1*fieldname2; })();
I want to always multiply the result, whatever it is, by 0.7. But I’m having trouble figuring out how to wrap the whole formula in *0.7.
I don’t want to edit each IF line with *0.7 because the formula is huge and its likely the multiplication factor will change from time to time.
Many thanks to anyone who can chip in with a fix!
Viewing 2 replies - 1 through 2 (of 2 total)
Viewing 2 replies - 1 through 2 (of 2 total)
- The topic ‘Multiple result by a factor’ is closed to new replies.