Null Value

[AleCruc94]

Hi,

I try to explain my problem:

 I have a zero value obtained through a set analysis (which means the at the maximum data I have, through a specific filter this value is not in my table, so it turns correctly zero)

then I want an another field which is obtained through the value above; infact if the value above is zero then I have to obtain 1 otherwise 2.

However it turns zero but is is not exacly zero because in the set analysis 

if(isNull(Sum({<pg_status= {'1'}, Direzione={'Global Markets'},DataPL_num_report = {"$(vMaxDataCalendar)"} >}Net_IAS_PL)/1000),
'1',
'2')

it gives me 2 and not 1

Some help??

thankss

[lorenzoconforti · Accepted solution]

If it the result is 0, then you shouldn't use IsNull. Unless I'm missing something

if(Sum({<pg_status= {'1'}, Direzione={'Global Markets'},DataPL_num_report = {"$(vMaxDataCalendar)"} >}Net_IAS_PL)/1000 = 0,
'1',
'2')

[AleCruc94]

Thank You so much, it works!