Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello I currently have empty values in my table and I would like to replace them with a "0".
I have already tried these solutions:
- if(isnull(FIELDNAME,0,FIELDNAME),
- if (FIELDNAME) = '-',0,FIELDNAME)
- if (len(trim(FIELDNAME) =0, 0, FIELDNAME))
-if (not Exist(FIELDNAME), 0 , FIELDNAME)
I need help please.
Hello @Balthazar ,
Try to add your field as measure and not as dimension and use this expression:
if(isnull(FIELDNAME),0,FIELDNAME)