Announcement

Collapse
No announcement yet.

Percentage Calculation

Collapse
X
 
  • Filter
  • Time
  • Show
Clear All
new posts

  • Percentage Calculation

    Hello All. I have been working on this all day but cant seem to get it figured out. I need to get the percentage between 2 numbers. For example This is for calculating the percentage of a budget that has been used.



    usedamount = (amountUsedConverted/totalBudgetAmountConverted)*100;


    does anyone have experience with this formula?

    Thanks

  • #2
    I think you have to use "usedAmount" instead of "usedamount"

    Comment


    • #3

      Comment


      • #4
        Hi Dustin,
        could you tell what is the type of the 'usedamount' field. Is it a currency? Basically your formula looks correct, but also you have to make sure that you are not trying to divide by 0. Check the logs file whether there is no error description that applies to your issue.

        Comment

        Working...
        X