Percentages Money Need Help

[BrianDH]

My user wants to see the percentage "used" based on two dollar amounts.   

num(sum(BH_AMOUNT_ACT) + SUM(BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE) + SUM(BH_AMOUNT_PAY) +SUM(BH_AMOUNT_OTHER) /SUM(BH_AMOUNT_BUD)
* 100)

Looking for help

[martinpohl]

that's a mathematical problem

num(

(

sum(BH_AMOUNT_ACT) + SUM(BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE) + SUM(BH_AMOUNT_PAY) +SUM(BH_AMOUNT_OTHER)

)

/SUM(BH_AMOUNT_BUD)
* 100)

isn't it?

Regards

[BrianDH]

OK, then how do I get the percentage of (Spend/Budget)?

[BrianDH · Accepted solution]

needed to be this

sum(BH_AMOUNT_ACT + BH_AMOUNT_GLA + BH_AMOUNT_GLL + BH_AMOUNT_GLQ + BH_AMOUNT_GLR + BH_AMOUNT_GLE + BH_AMOUNT_PAY + BH_AMOUNT_OTHER)
/SUM(BH_AMOUNT_BUD)