Skip to Content
0
Jul 12, 2022 at 08:14 AM

SAP Analytics Cloud - Advanced Formula copy values

409 Views Last edit Jul 12, 2022 at 08:59 AM 3 rev

Hi friends,

I want to copy values and used following script:

CONFIG.GENERATE_UNBOOKED_DATA = OFF
FOREACH.BOOKED [d/Material_Neu],[d/Production_Plant],[d/Customer_Sold_to]
	DATA([d/DBSCHEMA_COMA] = "COMA042_KS") = RESULTLOOKUP( [d/Material_Neu] = "1051",[d/Production_Plant] = "21")

ENDFOR
For my Account-Element "COMA042_KS" there is no value on the Material, Production Plant, Customer level.

I only have "COMA042_KS" values for Material and Production Plant (Customer is #)

As further information, I do have values on the combination Material and Customer for the Account-Element "COMA122".So my goal is now like this:If Material and Customer has booked values on COMA122

Then copy the value from COMA042_KS based on Material and Production plant to the COMA0421_KS based on Material, Production Plant AND CUSTOMER.

Could someone give an example script on how to do so. I think my script shown above isn't fine...Kind regards,Ismail