Details about this thread
  • State Verified Answer
  • Replies 3 replies
  • Subscribers 294 subscribers
  • Views 993 views
  • Users 0 members are here
Related content from around SugarClub

Simple Divide Formula

Rachel Craft

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 

Parents
  • +1

    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

Reply
  • +1

    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

Children