Calculated Dimension

[Anonymous]

Hi guys

I am trying to create a calculated dimension that only looks at invoice numbers that aren't 8 digits in length and begin with the number 5.

I have the following but it doesn't work, there is an error with the "-=" operator. Do any of you clever folks have any suggestions how I can amend this to work?

IF(LEN([Invoice Number] -= "8" AND WildMatch([Invoice Number],'5*'),'Barcoded',)

Many thanks,

Gareth

[Anonymous]

try this (only = instead of -=)

IF(LEN([Invoice Number] = "8" AND WildMatch([Invoice Number],'5*'),'Barcoded',)

[devarasu07]

Hi,

Try like this, if it's not working would be able to share your mock data and expected results tks

IF(LEN([Invoice Number]<>8 AND WildMatch([Invoice Number],'5*'),Barcoded)

or

aggr(IF(LEN([Invoice Number]<>8 AND WildMatch([Invoice Number],'5*'),Barcoded),Barcoded)

Thanks,Deva

[prieper · Accepted solution]

IF(LEN([Invoice Number] <> 8 AND WildMatch([Invoice Number],'5*'),'Barcoded')

edit: Typo

[Anonymous]

<> 8 for sure

[tresesco]

OR like:

IF( Not LEN([Invoice Number] = 8 AND WildMatch([Invoice Number],'5*'),'Barcoded')

[Anonymous]

Thanks all