Amount in certain currency is multiplied by 100 in bex report. Data in multiprovider is good. Suppose if amount is 123.123 in multiprovider then in Bex report it is showing 12312.3. This is happening where currency is HUF. I understand that I have to handle it at query level in bex. I also understand I may have to create formula variable/ CKF/ RKF. But not able to implement it. Please help me to solve this. I'm new in Bex.
Thanks in advance.