Can I deactivate column algorithms calculating "live"?

This may sound weird! But we would like the column algorithm to perform after we have saved the data entry so the figures in one column remain the same while planning

Answers

  • Unknown
    Unknown Active Partner

    Hi there Jack,

     

    You should be able to achieve this by having another set of blocks (that are hidden) in your layout, which are the same cubes that have data-entry enabled on them (in the existing blocks).  Then change the algorithm so that it's calculating on the "hidden" blocks, rather than the blocks where the user is doing data-entry.  I believe the values in the "hidden" blocks should not change until AFTER data-entry has been saved - so therefore the algorithm result would stay static until after date-entry is saved.

     

    Do a test and let me know if that achieves your desired result.

    Cheers,

    Craig Parris

  • Jack Footer
    Jack Footer Active Partner
    Fourth Anniversary 25 Up Votes First Comment

    Yes, awesome thank you! That seemed to work perfectly