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

Joseph Bustos

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')