To calculate Total of % values

[panipat1990]

Dear Team,

we have % values coming from back-end script. we are showing that value in Straight table but not able to show total of all % values.

Could you please help us to get total of % values in straight table. for this , have shared the data set with it.

Kindly check and suggest us the best solution if possible.

Thanks

Gourav

[sunny_talwar]

What is your current expression and have you enabled total for the %Value expression?

[panipat1990]

Hi Sunny,

yes that total mode is enabled.

i just want to know what formula we can write to show % value on straight table with the total % value on TOP row.

Thanks

Gourav

[sunny_talwar]

What is the expression you are using currently?

[panipat1990]

Avg(%Value)

[sunny_talwar]

I think you will need to use the other two fields instead of using your pre-calculated %Value field to do this. Is that okay? If it is can you provide the first two expression used?

[panipat1990]

Yes, that i know...

but can we calculate % on pre-calculated %value field?

[sunny_talwar]

AFAIK, I doubt that it is possible

[panipat1990]

okey.. then..can you ask to someone other in your circle please.

Thanks

Gourav

[sunny_talwar]

my circle? Gourav, like I said I don't think this is possible. If someone disagrees with me, he/she will respond right here. I don't have the time to go about ask around my friend. I am sorry if that's not what you expected.

Best,

Sunny