Formula check

[JoseGarcia]

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

[MayilVahanan · Accepted solution]

Hi @JoseGarcia 

Try like below

count({<[Valid_Until]={'-'},Course_Name={'Non-Technical Skills Awareness (NTS)'}>}Distinct Course_Name)

Hope, Valid_Until has value like '-'.

[JoseGarcia]

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