Calculated Dimesion - Syntax

[#1]

Hi i have a diagram whereby i wish to restrict my dataset to two values.

=if ([Tillv/köp-kod]= 3 and [Tillv/köp-kod] = 6, [Tillv/köp-kod])

however i see that in the column i recieve - as a value.

is the syntax potentially wrong?

Best,

Bradley

[sivarajs · Accepted solution]

If you want only 3 and 6 value you can use

if(WildMatch([Tillv/köp-kod],'3','6'),field1) else if you want the range between 3 and 6 you can go with

if([Tillv/köp-kod]>=3 and [Tillv/köp-kod]<=6,field1)