Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I want to check if for a certain SURVEY ID there is any sounding correction report.
So if there is any Sounding date they will show a sounding correction report.
If there are no sounding date value it will show no sounding correction reports.
I encountered a syntax error in my following code:
if( isNull([SOUNDING_START_DATE]) ,'No Sounding Correction Report Available','Sounding Correction Report Available');
Here SOUNDING_START_DATE IS A DIMENSION
Give a try as below:
if( Len(Trim([SOUNDING_START_DATE])))=0 ,'No Sounding Correction Report Available','Sounding Correction Report Available');
In addition to Raja's suggestion above you need to store the output of IF condition into a field / dimension using "AS".
if( Len(Trim([SOUNDING_START_DATE])))=0 ,'No Sounding Correction Report Available','Sounding Correction Report Available') as ReptAvailable;
Here ReptAvailable is a new dimension.
Hope this is helpful.
Thanks.