Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Is it possible to write an IF in an expression like
=IF(a<b, x = 1 AND IF(...) )
in my problem:
I have to check the date at first and if the date is smaller than a date in the future i want to set the status to YES and count the YESes.
I have a table with for example
Date1 | Status |
15-07-2019 | NO |
04-06-2019 | YES |
10-08-2019 | NO |
04-03-2019 | YES |
I need to check if Date < Date(MonthEnd(Today(),+1)
If yes, i want to count the YESes. So instead of the output 2 (two YESes at first) i want as output 3.
Date1 | Status |
15-07-2019 | YES |
04-06-2019 | YES |
10-08-2019 | NO |
04-03-2019 | YES |
I need an IF expression like in another table:
=IF(Date(date#(Date1,'DD-MM-YYYY'),' DD.MM.YYYY')<DATE(MonthEnd(Today(),+1), 'DD.MM.YYYY'),Status='YES' AND
IF(TestText='Total yes all ref', Count(If(Status='YES',Status))
Regards!
nr 1: pick(
Match(TestText,'Missing Due Date','Total yes all ref','A1 - NO','B1 - NO','C1 - NO','TOTAL')
,Count({<Duedate={''}>}Duedate)
,Count({<Status={'YES'}>}Status)
,Count({<Reference={'A1'},Status={'NO'}>}Status)
,Count({<Reference={'B1'},Status={'NO'}>}Status)
,Count({<Reference={'C1'},Status={'NO'}>}Status)
,Count({<Duedate-={''}>}Duedate)
)
the duedate field needs to be converted to a date or num field to create the setanalysis for duedate. When thats done you can use duedate={"<=$(=date(today()))"} or duedatenumber={"<=$(=floor(today()))"}
doesn't work for me...
i'll append the program for better understanding
nr 1: pick(
Match(TestText,'Missing Due Date','Total yes all ref','A1 - NO','B1 - NO','C1 - NO','TOTAL')
,Count({<Duedate={''}>}Duedate)
,Count({<Status={'YES'}>}Status)
,Count({<Reference={'A1'},Status={'NO'}>}Status)
,Count({<Reference={'B1'},Status={'NO'}>}Status)
,Count({<Reference={'C1'},Status={'NO'}>}Status)
,Count({<Duedate-={''}>}Duedate)
)
the duedate field needs to be converted to a date or num field to create the setanalysis for duedate. When thats done you can use duedate={"<=$(=date(today()))"} or duedatenumber={"<=$(=floor(today()))"}