Skip to Content
0
Aug 30, 2023 at 01:19 PM

How to Copy in SAC Value from e.g. FC3 to FC4 (advanced Formula)

50 Views

When copying the values from e.g. FC3 to FC4, the user does not want to select any periods. In FC 4 only the values from periods 4-12 should be copied. They should be derived automatically. We use Forecast layout with deriving the Forecast version and the cutoff dates from attributes of version.

image.png

The data action doesn't show any errors, but it doesn't copy any values either

image.png

image.png

Is it possible to automatically derive the period from the version in the data action?

what is missing in the formula?

Thank You!

Attachments

image.png (36.6 kB)
image.png (88.3 kB)
image.png (28.4 kB)