Exchange rate issue in report
I have a major issue in query designer. In my query I am fetching exchange rate from formula variable by replacement path. I am using exchange rate attribute of billing document. But most of the places exchange rate is coming 0.
I have checked in my inforovider ( Infocube) It is coming right there. One more thing this issue is for current month only In the same query I am fetching exchange rate for last year same month. It is fine.
I am surprise that same variable is giving right vale for the 'last year same month' but for 'current month' it is giving wrong value. and infoprovider value is correct for this month.
Please help me to solve this,