Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All ,
Would it be possible to create 3 values from one date filed.what I am expecting here
If date field is null show as Pend , if date field is not null show as complete and want to show if date field is total as Recieved
This is expecting
if(isnull(date ),'Pend',if(not Is null(date),'complete ',if(isnull(date)and if (is not null(date),'received') as newfield
I am able to getting two values that Pend ,complete
How to get two values total as received
Please guide me how to do it
I am able to get the proper values when I am use the following expression
=if(Flag='Received',count(ID),if(Flag='Complete',count({<Null_Flag={0}>}ID),
if(Flag='Pending',count({<Null_Flag={1}>}ID))))
dimension: Flag
don't know is this proper approach or not ?
see the below image
Would it be possible to share a sample to show the issue?