I have one metric in report which shows the percentage. I want to summarize these percentage values.

[Former Member]

I have one metric in report which shows the percentage. I want to summarize these percentage values. But when i am writting formula like sum(@percent) its giving me error message that says you cant summarize percentage field. How should i summarize percentage value.

[former_member183582 · Accepted solution]

Hi

Percentage column can't sum, you can use the following method to use sum percentage:

Item Name     Qty     in stock     percentage

00001               100     150          66%

00002               85          100         85%

Total               185          250          74%

You should sum both columns and then create a percentage field for the total percentage.

as you know that if we sum the percentage field it will give us wrong result.

Hope this will help you

Irfan

[Former Member · Accepted solution]

Your answer is partially correct , but my requirement is i want sum of column which have percentage values at total row.

             C     D            A          B

             60   30           60%     30%

             70   50           70%     50%

            ------------     -------------------

TOTAL 130  80                ?          ?

So , you said correct that we cant directly summarize the the cell where ? is displayed. So probably what i had done is these A and B fields are based on values of C and D , so i had sum the 60 & 70 and 30 & 50 , took there average and then got my percentage. So i will get following result which is correct,

             C     D            A          B

             60   30           60%     30%

             70   50           70%     50%

            ------------     -------------------

TOTAL 130  80           65%    40%      

               I think this result is correct.

[DellSC · Accepted solution]

Percentages are funny things - You CANNOT add them together and average them to get a meaningful value.  A percentage is like an average - an average of an average is not valid data.  So, you need to do a separate calculation that is the percentage over all of the data, not an average of the group percentages.

-Dell

[Former Member · Accepted solution]

Hi Dell,

     Could you please share the detail of the probable answer because this is now very confusing.

Thanks

Aniket

[former_member202170]

if is not summarizing percentages Please convert them into numbers and summarize those fields

If it is coming from Query or store procedure Please  convert in the Query or SP itself

get only values and do the summary as per your requirement in crystal reports

[former_member213692]

Hello,

Which version are you using? this is working fine for me in CRE 4.0 SP10. are you summarizing at group level or something else?

Thanks

Mike

[Former Member]

Hi Mike,

i am summarizing at column level.

[abhilash_kumar]

Hi Aniket,

I'm not too sure percentages are meant to additive.

Do you have an example/screenshot of what you're trying to do with the percentages?

-Abhilash

[Former Member]

Hi Abhishek ,

Suppose there is one column which shows in percentage format. CRE is not allowing me to directly apply sum function on percentage value. i ant to show the total of this column in one below section of this the section which contain this percentage value cell.

[abhilash_kumar]

CRE is not allowing me to directly apply sum function on percentage value

Are you trying to summarize a field that has been 'formatted' as a percentage or are you trying to sum a field that is already inserted as a summary (summary that shows as a percentage of group)?

-Abhilash

[Former Member]

that column cell already have formula which calculate percentage. And i have use this cell in second section. e.g. first cell named @percentage which have formula to give values like above .(60/80)*100=75 %, (50/80)*100=62%

Now i am using this @percentage in other cell as follows Sum(@percentage). So at this place it gave error that you cant summarize percentage field.

[abhilash_kumar]

Could you post a screenshot of the error please?

-Abhilash