Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
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
OK, then how do I get the percentage of (Spend/Budget)?
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)