if logic with null values

[bhavvibudagam]

Hi Experts,

Can any one please help me on below requirement.

Thanks in advance.

[gerry_hdm]

using

peek  or  previous

greetings gerry

[gerry_hdm]

if(FieldGroup = previous(FieldGroup)  and FieldCross <> previous(FieldCross),  peek('Crosswert') & '!'& FieldCross ,FieldCross) as Crosswert,

gruß gerry

[zebhashmi]

Not sure

if(Len(yourfield)<1,1,0)

[Anonymous]

i guess the IsNull-function performs better...

The IsNull function tests if the value of an expression is NULL and if so, returns -1 (True), otherwise 0 (False).