Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello community ,
i have a lil probleme with if,
i have a field that can take two values 'Pose' and 'Depose' and i want to have with my if expression '1' for 'Pose' and -1 for 'Depose'
my solution was : if([Pose / Dépose]={"Pose"},1,-1)
but that doesent work, i miss something?
Thanx
Hi,
Try like below,
if([Pose / Dépose]='Pose',1,-1)
Hello!
if([Pose / Dépose]='Pose',1,-1)
Hi,
try
if(wildmatch(fieldname,'Pose'),1,if(wildmatch(fieldname,'Depose'),-1))
or
if(wildmatch(fieldname,'Pose'),1,-1)
Regrds
I assume the field is called "Pose / Dépose"... Try this:
=if([Pose / Dépose]= 'Pose', 1,-1)
if([field] = 'Pose',1,-1)
work great, thanks everybody
works Great thanx a lot
Hi Teneman,
Try like this:
if([Pose / Dépose]={'Pose}',1,-1)
Ramya.