Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
i have like
monthnum:
05
06
07
08
09
before 05 i have null how to remove this ?
HI Manoj,
Null is supressed in List box I think it is empty spaces, use Trim() to remove blank spaces.
Try like this in script
Load
*,
If(Len( Trim (monthnum) ) > 0 , monthnum ) AS MonthNumWONull
FROM DataSource;
Or in front end give calculated dimension
If(Len( Trim (monthnum) ) > 0 , monthnum )
Hope this helps you.
Regards,
Jagan.
Hi,
can you post sample app with only the monthnum field loaded?
thanks
regards
Marco