Not applicable
2016-09-07
08:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
distribution of bonus
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
722 Views
1 Solution
Accepted Solutions
sunny_talwar
MVP
2016-09-07
09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
Count(NS)/Count(TOTAL <Client> NS)
or
Sum(NS)/Sum(TOTAL <Client> NS)
3 Replies
sunny_talwar
MVP
2016-09-07
09:16 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
May be like this:
Count(NS)/Count(TOTAL <Client> NS)
or
Sum(NS)/Sum(TOTAL <Client> NS)
Anonymous
Not applicable
2016-09-07
09:28 AM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Try with, Sunny T have already shared
Sum(NS)/Sum(TOTAL <Client> NS)
665 Views
effinty2112
Master
2016-09-07
09:41 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Hi Marina,
Something like this perhaps:
Sum(NS)/SUM(TOTAL <Client> NS) * logbonus/100
Cheers
Andrew