topic Re: How to calculate the total percetage on table? in App Development

How to calculate the total percetage on table?

kwl1234 — Tue, 04 May 2021 02:45:22 GMT

Total percentage should = 7154/27129=0.26370304839

How do I calculate the total percentage based on total value of Sum and GP?

I tried Column(3)/Column(1) also showing the wrong value(31.8%)

I also tried Sum(Total (Column(3)))/Sum(Total (Column(1))), but it is not working, return 0.

I also want to know about How to filter the dimension?

I want to filter B and C when I select year = 2021 and Month= 04.

I am filter the dimension by this expression:

If(Year & Month &99<Start Date, null(),Category)

Is there any proper way to doing that?

Re: How to calculate the total percetage on table?

MayilVahanan — Tue, 27 Apr 2021 10:46:52 GMT

Hi @kwl1234

Try like below

Sum(Aggr(Column(3) expression / (Column(1) expression) , Dimension1))

Column(3) expression <-- might sum(RevisedContractor)

Re: How to calculate the total percetage on table?

kwl1234 — Tue, 27 Apr 2021 10:58:44 GMT

Hi,

I tried the expression that you provide. it return the sum of % =975.3%. however, I would like final total % = Sum of column 3/ Sum of column 1 which is 26%..

Re: How to calculate the total percetage on table?

MayilVahanan — Tue, 27 Apr 2021 11:00:39 GMT

Can you send the sample file?