Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Guys,
i want to show percentages
data like
Input:
Data Q1 2021 %
A 170 ?
B 291 ?
C 19 ?
Total 480 100%
Output:
Data Q1 2021 %
A 170 35.4%
B 291 60.6%
C 19 4%
Total 480 100%
How to write Expressions.
Please help me,
Thanks in advance
Regards,
Subba
=sum(Q12021)/sum(total Q12021)
and change number format to %
output
Q1 2021 means i have writen this Expression
Count( distinct{<Date_Material={">=$(vLastQuarterStart)<=$(vLastQuarterEnd)"}>}requestid)
Hi Taoufiq ZARRA,
i want to show only jan 2021 data using set analysis,
Exe: count(requestid)
i have used this exp:
count({<Year={'vCurrentyear'},month={'vcurrentmonth'},milestone={'On'}>}requestid)
But not working..
please help me this.
Regards,
Subba