Formatting numbers and precentages in WEBI 4.1 SP5

[Former Member]

I am working on a report where the requirement is to display percentage values upto two decimal places and non-percentage values should be rounded up to the nearest integer value.I've used certain formulas to conditionally display the measures like If (condition) then " n/a" else output_value.How can I format the output_value according to the requirement.Please advise.

Thanks !!!

[Former Member]

Thanks everyone...I was able to get it to work by using FormatNumber function.

[former_member183241]

Hi Abhi,

Please mark the thread by selecting helpful answer or correct answer and close the thread

Thanks,

Kashif

[kalyansap]

Hi Abhi,

please provide the example with expected table format.so that you can get the precise solution to your question.

Thanks,

Kalyan.

[former_member183241]

Hi Abhi,

As per your requirement you have to show integer and decimal point values in webi report.Please follow below steps.

1) Right click on column and 'Edit Formula'

2) write formula using FormatNumber function like  FormatNumber(Value;"##")-for 2 digit integer value.

3) Repeat same process for decimal point percentage value.

Thanks,

Kashif Ali Khan

[Former Member]

Hi Abhi,

For Number formate use this code =if (condition) then "N/A" else FormatNumber(output_value;"####")

For Percentage      =if (condition) then "N/A" else FormatNumber(output_value;"####.00%")

Regards,

Raju Kushwaha

[Former Member]

can you please give some example what you wanted?