SAC Data Action - Copy Step - sing inversion

[edwin-romero]

Hello there.

In SAC, Im facing the need to invert default measure sign (+/-) in a Data Action Copy Step and I don't know how to do that or if im wasting my time due to is impossible. I mean, my measure in model A is positive (+) and i need to send it to model B but negative (-).

Do anyone knows how to solve this need?

[William_Yu · Accepted solution]

Hi edwin_romero,

Copy action can only copy the data as it is. You should use advance formula to achieve sign reverse value. Like:

DATA() = RESULTLOOKUP() * -1

Best regards, William

[edwin-romero · Accepted solution]

Thank you WIlliam, it was solved by creating two steps in the sac data action. The first one include your previous code line and the second one was just a normal copy step.

Regards.