Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
Hi @kwl1234
Try like below
Sum(Aggr(Column(3) expression / (Column(1) expression) , Dimension1))
Column(3) expression <-- might sum(RevisedContractor)
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%..
Can you send the sample file?