Expression error

[#1]

Hi All,

I am performing simple calculation, not sure why it is giving expression error. Please refer to the attached QVW and suggest.

[tresesco · Accepted solution]

Two issues at first glance:

• field names should be in capitals (F1,.... f1.....)
• Use Rangesum() instead of Sum()

Like,

=F2/Rangesum(F2+F3+F4) *100

[anbu1984]

Field names are case sensitive. Check this

[sivarajs]

Field name used is wrong its Starts with F. You can't directly use sum in dimension

Try,

F4/(F2+F3+F4)*100

[#5]

Hi Tresesco,

Thanks for reply. How can make only 2 decimals and '%' after value?

Thanks.

[tresesco]

May be like:

=Num(F2/Rangesum(F2+F3+F4) *100,'#,##0.00%')

[#7]

It is showing Expression error.

[#8]

Hi Anbu,

Thanks for reply. How can make only 2 decimals and '%' after value?

Thanks.

[#9]

Hi,

Instead of using the calculation in dimension, You can use the same in expression.

'=F2/RangeSum(F2+F3+F4) *100'

Then Go to Chart Properties--->Number---> Fixed to (2) decimals---> Enable 'Show in Percent'

Regards,

Joshmi

[#10]

Hi,

I am showing in the Dimension, not Expression. Hence I can't go to property and choose for these fields.

Thanks.