Post Author: Vorax
CA Forum: WebIntelligence Reporting
Good afternoon all,
I am using BO XI R2 (Webi), and have created multiple variables. The issue is that the variables are showing the cents of the figure even though I have formatted the cell. I assume it is because it is a string, and that I should use 'totext.' But I am not sure how to use it in this scenario. Your help is appreciated.
Displaying 38,540.48Should be displaying 38,540
Variable is=If(IsError([Impairment]);"";Average([Total Cost of Sales])+Average([Impairment]))