Have you tried using ILT inside the IFF to compare v1 and v2 variables. Sent from my iPhone
> On Jul 8, 2014, at 2:05 PM, "Dr. Fritz Luettgens" <[email protected]> wrote: > > Hi, > > year(col1) turnover(col2) info(col3) > 2011 3 > 2012 6 + > 2013 5 - > 2014 7 + > > I want to add to the info column "+" or "-" > with the UPDATE command using the > IFF function (IFF('.v1<.v2','+','-')) > but cannot get it working because I think I > need the year as reference. > Is there a different function I can use ? > Thank´s > fritz > >
