SAP Analytics Cloud for planning - Comparator Issue in Advanced Formulas

[guenay]

Hi friends,

Iam using following code, but it does not work.

IF [d/Customer_Sold_to]!=[d/Enhanced_Cost_Center].[p/Customer] THEN
	DELETE()
ENDIF

Neither this way works:

MEMBERSET [d/Customer_Sold_to]!=[d/Enhanced_Cost_Center].[p/Customer]

DELETE()

 To make sure, that there is no Data set issue I made following check:

MEMBERSET [d/Customer_Sold_to]=[d/Enhanced_Cost_Center].[p/Customer]

DATA()=RESULTLOOKUP()+10000000

 It works perfectly fine. 

So there must be some kind of issue with the comparator -> !=

Any ideas?

Kind regards
Ismail

@N1kh1l especially asking you!

[William_Yu · Accepted solution]

Hi guenay, 

   Please check  if '!==' would work in your case.    

Best regards, William