Skip to Content
0
Former Member
Jan 02, 2008 at 08:22 PM

BO XI R2 - Showing decimal places

22 Views

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]))