Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I need to flag the column if is there more than one record as 'Y' else 'N'.
I tried this (If(len("Make Good")>0,'Y','N') as "Make Good") but it gives the row level flagging. I need at column level flagging.
Required output:
Thanks..
@Krish2459_58 You can try the same with ValueList() as island tabular.
think you are trying to do it in the script editor? If so below code will work but using an aggregation function will mean you will have to use a group by also.
If(Count("Make Good")>0,'Y','N') as "Make Good"
but you can also do in a table object (not script), create an expression like this: If(Count("Make Good")>0,'Y','N') and give the expression a label
try below
=if(Count(Distinct TOTAL [Make Good])>0,'Y','N')
@Krish2459_58 You can try the same with ValueList() as island tabular.
think you are trying to do it in the script editor? If so below code will work but using an aggregation function will mean you will have to use a group by also.
If(Count("Make Good")>0,'Y','N') as "Make Good"
but you can also do in a table object (not script), create an expression like this: If(Count("Make Good")>0,'Y','N') and give the expression a label
try below
=if(Count(Distinct TOTAL [Make Good])>0,'Y','N')
Hi,
Tried this and it works.
if(count(if(len("Make Good")=0,null(),'1'))>0,'Y','N') as "Make Good"
Thanks..