How to get the quotient of a data in Qlik Sense?

[kristeljoymalapitan]

Spoiler

Good Day,

I have below sample data in qliksense which I need to get their quotients  per dealer name, i need to do this in edit expression (measures) dealer name and balance column has the same source.

Hope someone can answer my concern. Thank you

sample data:

dealer name	balance	formula	expected output
laguna	1000	1000/7000	14.29%
makati	2000	2000/7000	28.57%
batangas	4000	4000/7000	57.14%
TOTAL	7000

[Anil_Babu_Samineni · Accepted solution]

Check this

Num(Sum(balance)/Sum(TOTAL balance), '#.#0%')

[kristeljoymalapitan]

Hi @Anil_Babu_Samineni 

 Data is only correct when I do filterization per month.

If display as per historical per month percentage/result s are not correct, you may refer to attached screenshots for your reference

Thank you