Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have a Straight table with multiple fields/columns.I have a requirement to hide a column Post_Address when Post_Address=NA for a particular ID
and another column Child_Num when Child_Num=0 for list of ID's.
already tried with the below
if(Post_Address<>'NA',Post_Address)
SubStringCount(Concat(ID,'|'),1002)>>0
If(IsNull(POSTAL_CD),0,1) ---->This is not applicable
Please suggest if anyone have any idea?
Thanks in advance.
Just Repeat the Only() function with an OR in between.
If( Only(Post_Address) = 'NA' OR Only(Post_Address) = '0', 0 , 1)
Cheers..
Thanks Matthew