Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
HI All,
i have one expression.. like
sum(countid) / sum(total NoAmount)
Percentage wise it should be 100 % right ??
but i am getting above 100 % value..
Please can anyone help me out....
Hi,
If sum(countid) is greater then sum(total NoAmount) then you will get more then 100%, can you attach sample file and your expected output.
Regards,
Jagan.
Hi Paul,
Please attach the sample file so that we can check in detail
Hi Paul,
Percentage can be displayed more than 100 %.
For example if sum(countid) gives 4500 and sum(total NoAmount) gives 800, then percentage becomes 562.5% ((4500/800)*100).
Paul Walker wrote:
.....
sum(countid) / sum(total NoAmount)
Percentage wise it should be 100 % right ??
Not really necessary. Had the expression been like: =sum(FieldA) / sum(total FieldA) (i.e - aggregations against same field), your expectaion would hold good.
try
sum(countid) / sum(total <countid> NoAmount)