cancel
Showing results for 
Search instead for 
Did you mean: 

SAP Analytics Cloud for planning - Comparator Issue in Advanced Formulas

guenay
Participant
0 Kudos

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!

View Entire Topic
N1kh1l
Active Contributor

@guenay 

Try this. You can try without booked option if it does not work.

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

 

You can also try this

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

 

Hope this helps !!

Nikhil

 

guenay
Participant
0 Kudos
Hi @N1kh1l thank you for your contribution. The answer from William was the better fit. But Iam looking forward hearing from you on other Questions.
N1kh1l
Active Contributor
Ismail, Indeed Williams answer is correct. I overlooked the single operator usage .