Display decimals in Formula variable
I have a CHAR field(Say A) which has only numbers coming in such as 10.85 , 12.78 etc . Now I have created a Formula variable (Say B) in Bex so that I could use this in some calculations . The formula variable is defined on this CHAR field with following properties : Replacement on A , Dimensions to Number.
When I run the report , I get values rounded in B as 11 , 13 instead of 10.85 and 12.78 . I checked the display properties of formula variable ,made it to 3 decimals...but still the out put remains rounded values.
Appreciate for any help,