This content has been marked as final.
Show 5 replies

Re: How do I calculate the ratio of a sum total by each number of rows.
Sunny Talwar Aug 16, 2016 10:27 AM (in response to Shivam Sarin)May be this:
Sum(UNITS)/Sum(TOTAL UNITS)
or
Sum(TOTAL UNITS)/Sum(UNITS)

Re: How do I calculate the ratio of a sum total by each number of rows.
Shivam Sarin Aug 16, 2016 10:45 AM (in response to Sunny Talwar )Many Thanks, It worked

Re: How do I calculate the ratio of a sum total by each number of rows.
Sunny Talwar Aug 16, 2016 12:05 PM (in response to Shivam Sarin)Did you mark you own answer as correct by mistake .
I would suggest marking the response which is actually correct, so that future users can find it useful when they land on this page.
Qlik Community Tip: Marking Replies as Correct or Helpful
Best,
Sunny

Re: How do I calculate the ratio of a sum total by each number of rows.
Shivam Sarin Aug 17, 2016 1:33 AM (in response to Sunny Talwar )Oops Sorry, My bad. I corrected my mistake.




Re: How do I calculate the ratio of a sum total by each number of rows.
Allu Allu Aug 16, 2016 10:34 AM (in response to Shivam Sarin)Hi
try this !!!
Sum(Store Sales) /
Max(TOTAL Aggr(Sum(Store Sales),STR_ACCOUNT_NAME_DESC) ))
OR
Max(TOTAL Aggr(Sum(Store Sales),STR_ACCOUNT_NAME_DESC) ))/Sum(Store Sales)