asked 2 days ago
Hi Flexmonster Team,
We’re experimenting with editable fields in a Flexmonster Pivot Table using the following configuration:
https://jsfiddle.net/3mcaexv4/16/
We’re trying to achieve the following behavior:
Make both "Actual" and "Progress" fields editable.
When a user edits "Actual", we want "Progress" to update automatically based on the formula ('Actual' - 'Price'), and vice versa.
Is this possible with Flexmonster? We understand calculated fields are typically read-only, but we’re hoping for editable calculated fields with dependency tracking or bidirectional updates between them.
Looking forward to your guidance or any available workaround.
Best regards,
Gergely Konrad
⋅ 1 day ago
Hello, Gergery!
Thank you for reaching out to us.
Currently, Flexmonster does not support editing calculated values or making bidirectional updates between the calculated value and the values that compose it. We are not planning to add this feature in the future due to a conceptual issue: with a formula like 'Progress' = 'Actual' - 'Price', it is unclear which value should change when the calculated value is changed. This ambiguity makes consistent behavior hard to define.
Please let us know if any other questions arise.
Best Regards,
Maksym
