topic Re: Percentage Calculation in App Development

Percentage Calculation

Ayoub — Fri, 24 Sep 2021 11:02:16 GMT

Hello Community ,

i'm facing a little problem with my new application , on the chart i wanna calculate the percentege of my Dimension by year like this : ( As you can see the %Sales on red is calculated by deviding 585 788 by 771 397 )

The EXPRESSION I WROTE IS : Count(DISTINCT Sales )/Count(TOTAL DISTINCT <Ex> sales) but it doesn't give me the result i want

Ex.	Pack Gar	Total sales	% sales
2020	P1	585 788	76%
2020	P2	142 815	19%
2020	P3	57 890	8%
2020	P4	164	0%
2020	Total	771 397	100%
2019	P1	598 953	78%
2019	P2	149 498	19%
2019	P3	41 163	5%
2019	P4	24	0%
2019	Total	772 540	100%

i tried so many expression by the way, but none of them worked for me .

I really hope u helping me .

Thank you once again

Re: Percentage Calculation

akshatagrawal — Tue, 28 Sep 2021 09:24:22 GMT

Can you please help in understanding whether total for each year will be same as P1+P2+P3+P4 or not.

In data I can see it differs.

Re: Percentage Calculation

MindaugasBacius — Tue, 28 Sep 2021 09:38:40 GMT

Do field Sales represent Sales ID or number?

I guess try using Sum instead of Count.

Re: Percentage Calculation

PrashantSangle — Tue, 28 Sep 2021 09:45:17 GMT

Yes @MindaugasBacius is correct. try below code

Sum(Sales) / Sum(Total <Ex> Sales)

Re: Percentage Calculation

Ayoub — Fri, 15 Oct 2021 10:42:51 GMT

yes i agree with both of youu ! but the situation obliged me to use count instead of sum..
cuz i wouldn't put some secret info so i used and example by sales .

So THE SOLUTION was pretty similar :

Count(DISTINCT IMMATRICULATION)
/
Count( DISTINCT TOTAL <Ex_gar_auto> IMMATRICULATION)

Thank you @PrashantSangle & @MindaugasBacius for ur kind time.. and sorry for my late response .