Regarding Total

[sarfaraz_sheikh]

Dear All,

I want to calculate %Calculation like below ...

                                     Afabulous                           BPerformance                                       CExcellent                                         Sum of salary                 212000                                   104000                                                57000              

%Calculation                   100%                             104000/212000*100= 49.05%               57000/212000*100= 26.88%              

how i can achieve the same ...kindly suggest..

Sarfaraz

[#2]

Hi Sarfaraz,

First declare one Variable

vFab = Sum({<Remarks={'AFaboulous'}>} SALARY)

Then use following expression in %Claculation

=Sum(Aggr(Sum(SALARY), Remarks))/$(vFab)  *100

Regards,

Faisal