Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I would need some help whereby the following 2 conditions need to be fulfill for me to count the number of [Schedule End date] occurrence
[Type]="OQ" and [Routine Schedule]='Yes',
Type | Routine Schedule | Schedule End Date |
PM | Yes | 09 Mar 2021 |
OQ | No | 09 Mar 2021 |
Cal | Yes | 09 Mar 2021 |
Cal | No | 09 Mar 2021 |
PM | Yes | 09 Mar 2021 |
OQ | Yes | 09 Mar 2021 |
PM | Yes | 09 Mar 2021 |
OQ | Yes | 09 Mar 2021 |
PM | No | 05 Mar 2021 |
PM | Yes | 05 Mar 2021 |
PM | Yes | 05 Mar 2021 |
Below is my expression and it doesn't work.
Count(if ([Type]='OQ', [Routine Schedule]='Yes',[Schedule End Date]))
Thanks
Hi
This should work for you
Count(if ([Type]='OQ' and [Routine Schedule]='Yes',[Schedule End Date]))
Hi
This should work for you
Count(if ([Type]='OQ' and [Routine Schedule]='Yes',[Schedule End Date]))