How to calculate percentage ?

[Subba55]

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

[Taoufiq_Zarra]

@Subba55 

=sum(Q12021)/sum(total Q12021)

and change number format to %

output

[Subba55]

Q1 2021 means i have writen this Expression

Count( distinct{<Date_Material={">=$(vLastQuarterStart)<=$(vLastQuarterEnd)"}>}requestid)

[Subba55]

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