Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have a requirement to show, if CCA_ROW_34B has more than 2 GROUP_CODE values I have to show as 'Partial', else show as 'full'.
GROUP_CODE | CCA_ROW_34B | Expected Output |
3 - Undated capital | Full | |
4 - Subordinated notes | Partial | |
CFS1 | 4 - Subordinated notes | Partial |
HGHQ | 1 - Ordinary notes | Full |
HGHQ | 2 - Third dollar notes | Full |
HGHQ | 4 - Subordinated notes | Partial |
If there are no NULLs in GROUP_CODE, then
Coalesce(Only(CCA_ROW_34B),'Partial')
should work.
Otherwise, you could try
If(Count(CCA_ROW_34B)<=1, Only(CCA_ROW_34B), 'Partial')
Try
Coalesce(Only(Flag),'Partial')
Thank you Henric for your reply,
I have updated the exact requirement, please check and suggest.
If there are no NULLs in GROUP_CODE, then
Coalesce(Only(CCA_ROW_34B),'Partial')
should work.
Otherwise, you could try
If(Count(CCA_ROW_34B)<=1, Only(CCA_ROW_34B), 'Partial')