NPrinting 18 Pixel Perfect Currency Null

[lanlizgu]

Hi,

I am giving currency format (format string {0:#,# €}) to different expressions. The thing is that once the format is given, for the registers without data, the € symbols shouldn't appear and is showing. How could I avoid displaying the € for the values without data?

Thank you.

[harshan28]

Give the number format on conditional basis like

If(Isnull(Expression), Expression without Currency,Expression with currency)

[pradosh_thakur]

alt(expressionwith currency,' ')

[lanlizgu]

give the number format in Format String?

[harshan28]

Give the number format like this

IF(Isnull(Sum(Sales)), Num(Sum(Sales),'#,##0'),Num(Sum(Sales),'#,##0$'))

Change  currency and number format as per your requirement in the above expression.

[lanlizgu]

Thanks Harshan28, However, what I am expecting is to format the numbers in the "Format String" option of NPrinting, not formatting them in the expression.

[lanlizgu · Accepted solution]

At the end I am able to delete the € by formatting the expresions like this 

if(Sum(Expression)='0','',Sum(Expression))

and using the format string of nprinting designer as I was using ({0:#,# €}).

I was expecting to avoid modifying the expressions but it seems to be the best option.