SAC Planning Advanced formula code clarification.

[praveen_kumar334]

Hi Team,

Can someone please help me in understanding the below piece of code. 

DATA([d/Measures] = "ABC") 
	= RESULTLOOKUP([d/Measures] = "M1", [d/Version] = "VERSION1", [d/Date] = "202101", [d/DIM2] = "#")
	* (RESULTLOOKUP([d/Measures] = "M2", [d/Version] = "VERSION1", [d/Date] = "202101", [d/D3] = "#", [d/D4] = "#",[d/MATERIAL] = "#", [d/t.S:SAP_ALL_COSTCENTER] = "#", [d/CCACTIVITYTYPE] = "#", [d/FIXVARIABLE] = "#", [d/COMPQUANTITY_UNIT] = "#") * 0 + 1)

Here I am confused with the last piece of code * 0 + 1. Can someone please help me on this.

[hartmut_koerner]

This formula takes measure M1, but only if there are data in measure M2.

Multiplikation makes a join, *0+1 sets the join partner to 1 so that the left side is multiplied with 1 - but only if there are data on the right side.