ISBLANK = 0 not holding when measure is formatted

[Anonymous]

I have a column within a matrix containing different measures, one of the values is formatted in the following format:

"(" & FORMAT([Measure], "£#,#") & ")"

In some cases the measure returns a NULL value, and appears like this: (£)

I want it to appear as (£0) if possible but can't find a way to do this. I created this measure and tried to insert it but to no avail:

New Measure = IF(ISBLANK([Measure]),0,[Measure])

It still returns (£) within the matrix column, despite showing £0 when placed in a card. Any help is much appreciated.

Many thanks

[AilleryO]

Hi,

Could it work without test if your format formula is :

"(" & FORMAT([Measure], "£0,#") & ")"

Just replacing in your format the # by a 0, to force the display of it in any case. 

Is this working ?

[Anonymous · Accepted solution]

Hi,

Very close, it worked with the following:

"(" & FORMAT([Measure], "£#,#0") & ")"

Many thanks! 

[az38]

@Anonymous 

it is complicated question, to give a correct answer we need to see a little bit more - for example, [Measure] statement.

Now I can recommend to do

New Measure = IF(ISBLANK([Measure]),0,[Measure])

"(" & FORMAT([New Measure], "£#,#") & ")"