SAP Analytics Cloud - Data Action Copy generates zeros from Null

[GiuliaSal]

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

[William_Yu1 · Accepted solution]

Hi giulia.salani.mtm,

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

Best regards, William

[GiuliaSal · Accepted solution]

Hi William,

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

Best Regards,

Giulia

[m_singh · Accepted solution]

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