Percentage Share (%A) giving the reverse sign values in BEx report

Hi All,

I have below problem in the BEx Analyser.

I wrote formula like : Net Price Variance % = NDVIO ( 'Net Price Variance $' %A 'Previous Period' )

here I use Percentage Share (%A) to display the % symbol in report.

while displaying the data in report the data is showing Negative values as positive values and positive values as negative values like below

negative value / positive value = negative % is wrong

positive value/ positive value = positive % is wrong

If I remove this Percentage Share (%A) from the report, report will not display the % Symbol, User wants this.

can any one have idea on this problem?

Thanks in Advance,

Madhu