How would I put this into an IF statement but I have an IF statement already so I need an IF with an IF.
If ( If =left([PV_Case.Quote No_],8) = [PV_Case.Sales Order No_] , not converted, else converted.)
You can definitely use nested if statements or expressions.
I cannot see where the problem is...
Could you please give use some more information?
Please elaborate more or you can try this
If( [PV_Case.Sales Order No_] = left([PV_Case.Quote No_],8) , not converted, else converted.)
Great that's what i was after i will test at work tomorrow.
i will try to explain a bit better,
Thanks Anand Chouhan & Agis Kalogiannis
if([PV_Case.Sales Order No_] = left([PV_Case.Quote No_],8) , 'Not Converted', 'Converted') as [PV_Case.Conversion_Status],
the statment now works and i have placed it into the script. how do i add a distinct into the expression?
Retrieving data ...