I have dimension where I should select by contract numbers.
Purchase contracts begin with P and looks like P00934875
Sale contracts begin with S and looks like S_238098346237
I want to create variable and group all purchase or sale contracts.
I use match function and create different variables like
=If Match([Contractno];"%p%") Then "Purchase" ElseIf
Match([Contractno];"%S%") Then "Sale"
=if Match ([Contractno];"p*") Then "Purchase" ElseIf
Match([Transrefid];"s*") Then "Sale"
no one of these help me. What is correct syntax for match function? Please help me with this issue.