1 Reply Latest reply: Oct 15, 2011 10:08 AM by Hans Torsvik RSS

    Exists and Notexists function, can it be used in the same calculated dimension on the same field

      I think i may have a syntax errrow for my below formula, which is attempting to evaluate my shipTo Customer number for the current year $(CYear) and the previous year $(PYear) to determine if the customer number is new or existing



      =IF(Exists(s$(CYear)[ShipTo Customer]) and Notexists(s$(PYear)[ShipTo Customer]), 'New','Existing')