Need a help to calculate Accuracy

[SatyaPaleti]

Hi Folks,

Attached is the data...

I want to create line chart by using expression 1-(fabs([Quantity])/[Real Qty]) and dimension is Date.

But I am Unable to see the values

I am getting output as following

Result should be in percentage.. Here I am getting output. it's displaying only 100% I want to show all the data.

Could any one one help how to resolve this issue. It's Really Needful

Thank you,

Satya Paleti

[Clever_Anjos]

Maybe is related to your data, it would be easier to help with some sample of your app

[sasiparupudi1]

please post your data

[Kushal_Chawda]

Please post the sample.

Perhaps you can try

Use expression - num(fabs(sum([Quantity]))/sum([Real Qty]),'##.00%')

[CELAMBARASAN]

Try the below one

1-(Sum(fabs([Quantity]))/Sum([Real Qty]))