distribution of bonus

[#1]

Hi

help me please=)

I want to get the last column in the file excel.

I have a summary table and two attributes Client and Product ( but in real i have 5 attributes) .

Thanks

[sunny_talwar · Accepted solution]

May be like this:

Count(NS)/Count(TOTAL <Client> NS)

or

Sum(NS)/Sum(TOTAL <Client> NS)

[Anonymous]

Try with, Sunny T‌ have already shared

Sum(NS)/Sum(TOTAL <Client> NS)

[effinty2112]

Hi Marina,

Something like this perhaps:

Sum(NS)/SUM(TOTAL  <Client> NS) * logbonus/100

Cheers

Andrew