# New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Support Case Portal has moved to Qlik Community! Read the FAQs to start exploring Support resources.
cancel
Showing results for
Did you mean:  Creator II

## Percentages Money Need Help

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

Labels (2)

• ### percentage

1 Solution

Accepted Solutions  Creator II
Author

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)

3 Replies  Partner

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  Creator II
Author

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

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) Tags
Community Browser