07-20-2024 12:17 AM
Hello Experts
i'm trying to create a report to calculate fcst numbers based on driver. for driver, i'm using dynamic calc where i'm taking 3 month moving avg as %. my user wants the ability to tweak %. how can i do that? if i add an additional column and ask my user to just enter change in %, i can add both columns using cvc. but the accounts in my rows are parent members. i cant save data at parent and i do not want to use text properties for accounts.
07-29-2024 08:48 PM
If a user needs to edit the percentage, I would suggest changing the dynamic calc to a stored formula. This will allow the user to edit the calculated value.