Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hey everyone,
I would like to know how to write a expression that will check if a particular expression start with the given letters.
For example i would like to check if my [Project Name] field starts with "CPM_" .
I don't know how to express this.
Thank you for your help
Hi
Try like this
= Count({<ProjectName = {'CPM_*'}>}Sales)
Or
If(WildMatch(ProjectName,'CPM_*'), ProjectName)
Hope that helps
Hi
Try like this
= Count({<ProjectName = {'CPM_*'}>}Sales)
Or
If(WildMatch(ProjectName,'CPM_*'), ProjectName)
Hope that helps
Arnaud
Use the WILDMATCH function.
Best Regards, Bill
Use WildMatch
WildMatch([Project Name], 'CPM_*')
Thank all of you for you help.
I used this expression : sum(If(WildMatch([Project Name],'CPM_*'),1,0)) to know the number of projects starting with CPM_.