Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I need to count course name 'Non-Technical Skills Awareness (NTS)' entries that contain Valid_until '-'
Formula below is giving me error:
count({<[Valid_Until]={'-'}>},Course_Name={'Non-Technical Skills Awareness (NTS)'})
Can anyone help.
Thanks a million
Jose
Hi @JoseGarcia
Try like below
count({<[Valid_Until]={'-'},Course_Name={'Non-Technical Skills Awareness (NTS)'}>}Distinct Course_Name)
Hope, Valid_Until has value like '-'.
Hi @JoseGarcia
Try like below
count({<[Valid_Until]={'-'},Course_Name={'Non-Technical Skills Awareness (NTS)'}>}Distinct Course_Name)
Hope, Valid_Until has value like '-'.
Hi Mayil, If I wanted to replace {'-'} for a date entry?
How could I change the formula?
count({<[Valid_Until]={'-'},Course_Name={'Non-Technical Skills Awareness (NTS)'}>} Course_Name)
Thanks a million