Reverse Algorithm to Hidden Data Block
Hi All,
In version 10.3, I am using a column algorithm that pulls a value from one of two hidden data blocks, with reverse data entry into one of those data blocks. While it seems to pull the initial value correctly, I cannot seem to save the data entry on the hidden block and the values never update.
Do reverse algorithms only work when the reversed algorithm updates a visible data block?
To give more context, what I am trying to achieve is for each month of a financial year either show a locked actual figure or an open forecast figure.
My approach is to have an actuals period map data block, an actuals data block, and a forecast data block for data entry that are all hidden.
A column algorithm displays either actual or forecast based on the period map, is locked using the period map, and reverses data entry into the forecast block.
As mentioned this picks the correct value and the correct months are open for data entry, however saving does not seem to save the value in hidden forecast data entry block.
Not sure if I am missing something or this feature doesn't work as I expect. I am open to different approaches as well.
Thanks for any assistance.
Dan
Answers
-
I worked out that it does work on hidden data blocks.
The actual issue is that it does not work when using the detail by field. In the above example I was using detail by month in order to include other data blocks not related to month.
1