Need Help

[paulwalker]

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....

[jagan]

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.

[avinashelite]

Hi Paul,

Please attach the sample file so that we can check in detail

[timanshu]

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).

[tresesco]

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.

[MK_QSL]

try

sum(countid) / sum(total <countid> NoAmount)