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,