Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have the data as below, just few records as ex.
EID | T_Start_D | Due_D |
1 | 1/22/2018 | |
2 | 2/23/2017 | _ |
3 | _ | 9/23/2017 |
4 | 3/6/2019 | 2/23/2011 |
5 | 2/23/2017 | 9/23/2007 |
6 | 2/23/2017 | 2/13/2008 |
7 | _ | _ |
8 | 2/23/2017 | 2/23/2017 |
In Straight table, I need to show if the fields 'T_Start_D' and 'Due_D' are having values as Null or (_) values show as 'Not Required'
Thanks & Regards,
Heena Kauser
Try this?
If(IsNull(T_Start_D) or Match(T_Start_D, '_'), 'Not Required') -- for T_Start_D
If(IsNull(Due_D) or Match(Due_D, '_'), 'Not Required') -- for Due_D
Hi ,
I tried this below, Not working.
=if(
(If(len(trim(T_Start_D))= 0 , 'Not Required') )
and
(If(len(trim(Due_D))= 0 , 'Not Required') )
,'Not Required')
Thanks & Regards,
Heena Kauser
Null part may work but not "_" one since Len('_') calculate as 1. So, It is false.
Anyway, Did you try mine?
Hi,
=If(IsNull([Due Date]) and
IsNull([Target Audience Start Date])
, 'Not Required')
Not working.. I need both fields
Thanks & Regards,
Heena Kauser
Sorry, My Bad. Its NULL '-' only, I have typed as '_'
Are you expecting similar below image? If so, use expression as follows
If(Len(T_Start_D)=0 or Match(T_Start_D, '-') or Len(Due_D)=0 or Match(Due_D, '-'), 'Not Required')
Hi,
I need this as below.
EID | T_Start_D | Due_D | Expected |
1 | 1/22/2018 | ||
2 | 2/23/2017 | _ | |
3 | _ | 9/23/2017 | |
4 | 3/6/2019 | 2/23/2011 | |
5 | 2/23/2017 | 9/23/2007 | |
6 | 2/23/2017 | 2/13/2008 | |
7 | _ | _ | Not Required |
8 | 2/23/2017 | 2/23/2017 |
Thanks & Regards,
Heena Kauser
Hi,
I tried, I am not getting the correct result.
the expected result I want is, if both date fields are Null, then the calculated field should be shown as ' not required'.
Thanks & Regards,
Heena