I might be having a slow morning, but I need a calculated field that divides another field in the same module by 12 to calculate a monthly fee. I can't seem to get the right formula. What am I doing wrong?
Thanks
I might be having a slow morning, but I need a calculated field that divides another field in the same module by 12 to calculate a monthly fee. I can't seem to get the right formula. What am I doing wrong?
Thanks
Hi Rachel,
You can use the Sugar Logic function called as divide to acheive this.
Go to studio and select the field which should be dependent on parent field and check the calculated value checkbox and enter
the formula as divide($monthlyrevenue,12) and save the field.
Note: replace $monthlyrevenue with your field name in the formula.
Hope this should work for you.
Thank you,
Poojitha.K
Perfect, thank you so much. I don't think I have had enough coffee :-)
@Rachel Craft Just as a suggestion, add an ifElse validation to the field:
ifElse (equal ("<field name>", null), divide ($ monthlyrevenue, 12), $ monthlyrevenue)
Because otherwise every time the record undergoes a change in any of its fields or an automatic update, your field will be affected with new values if it is the case.