Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
In my table I have a selection of Terminals but need to get the percentage of each terminal type vs the total amount.
In the table it gives me the total at the top of the table but I cant figure out the expression for the number vs the total.
Here is my expression:
=Count({<YearMonth={'$(vCurrentMonthYear)'},Day={"<=$(vMaxDay)"},$(vOmitSelection_YearMonth)>}Distinct [Terminal ID])
I would imagine and have tried to use '/' but to no result.
Does anyone know how to do this task?
Thankyou in advance
Hi Have you tried adding the Total qualifier into the denominator part of the expression such as
=Count({<YearMonth={'$(vCurrentMonthYear)'},Day={"<=$(vMaxDay)"},$(vOmitSelection_YearMonth)>}Distinct [Terminal ID])
/
Count(Total {<YearMonth={'$(vCurrentMonthYear)'},Day={"<=$(vMaxDay)"},$(vOmitSelection_YearMonth)>}Distinct [Terminal ID])
Kindest regards
B
Hi Have you tried adding the Total qualifier into the denominator part of the expression such as
=Count({<YearMonth={'$(vCurrentMonthYear)'},Day={"<=$(vMaxDay)"},$(vOmitSelection_YearMonth)>}Distinct [Terminal ID])
/
Count(Total {<YearMonth={'$(vCurrentMonthYear)'},Day={"<=$(vMaxDay)"},$(vOmitSelection_YearMonth)>}Distinct [Terminal ID])
Kindest regards
B
Thanks very much, I have accepted as solution.
Best Regards,
Cameron