set analysis to check length

[#1]

Hi All,

Can please guide me on how to type the following using set analysis:

sum( if( len(Field1)=0 or Field1=1, amt))

Thanks!

[CELAMBARASAN]

Hi,

     Try this

     Sum({<Field1={"=(Field1=1) OR (Len(Field1)=0)"}>} amt)

Celambarasan