Question Re: SAP Analytics Cloud - Data Action Copy generates zeros from Null in Technology Q&A

SAP Analytics Cloud - Data Action Copy generates zeros from Null

GiuliaSal — Tue, 29 Nov 2022 16:59:19 GMT

Dear Experts,

we created a Copy step in Data Action and the issue is that when we copy from a Null cell, it overrides the values in the destination with zero. How can we prevent this issue? We would like to keep the destination as it is, if the source is Null.

Example:

Before executing the copy from "Premio Portafoglio" to "Premio Fixed":

After executing the copy step, our values are posted to zero, instead of keeping them untached:

This is our Data Action:

Thank you in advance for your help.

Best Regards,

Giulia

Re: SAP Analytics Cloud - Data Action Copy generates zeros from Null

William_Yu1 — Wed, 30 Nov 2022 01:29:46 GMT

Hi giulia.salani.mtm,

Maybe you could use advance formula step instead of copy step in this case.

Best regards, William

Re: SAP Analytics Cloud - Data Action Copy generates zeros from Null

GiuliaSal — Wed, 30 Nov 2022 09:20:26 GMT

Hi William,

thank you for your suggestion, we solved the issue using an advanced formula.

Best Regards,

Giulia

Re: SAP Analytics Cloud - Data Action Copy generates zeros from Null

m_singh — Tue, 04 Mar 2025 13:00:06 GMT

Can you please share the code you used in advance formula. In my case even after using the Advanced formula, i am not able to get rid of the 0.00.

Best Regards