Formatting issue when a Number field is used in formula

building reports webintelligence
1

n my report I am using “GL Fiscal Year” which is a dimension object from the universe. It is a Number field with format in designer specified as “0”. So I dont want to see any comma or decimals when displayed in my report.
It works as expectd when I use it in cross tab, table or chart. However When I put a Max or Min around it, it puts a comma in there. In a cell which is meant to give information about the report, I am using the below formula. However the output shows with 2,018 and 2,017 instead ot 2018 and 2017. I could not find a ToString or ToChar functions. So I have tried to use Concatenation. I also tried using +.

How can I change the field so that it displays

“Comparing Year 2018 over 2017”
instead of
“Comparing Year 2,018 over 2,017”

Minimearts (BOB member since 2018-11-12)

2

You can use FormatNumber() function

Here is an example

="Comparing Year " + FormatNumber([BoB This Year];"0000") + " over " + FormatNumber([BoB Last Year];"0000")

buzz :australia: (BOB member since 2005-08-12)