Yes. It's possible.If your Input control is based on Booked values, then you need to enable Cascading effect. If you do not any booked Actuals, you can write a data action to initialize valid combinations with a dummy data to enable cascading option....
Account dimension behaves similar to a measure.1. You can create Restricted account Or you can use this function in Calculated Measure. Need more details on the requirement.
You can try this approach:1. Input template to plan Asset Acquisition (This will also contain the period to start depreciation)2. Input template to maintain useful life by Asset Class (You can avoid getting it as a parameter in Data action)You can de...
Step 1: Calculate Cumulative Cost in a VariableStep 2: Calculate Cumulative Flag as well to simplify. If blank, 0.Multiply Cumulative Amount and Flag.Your result would be something like this. 2025.012025.022025.032025.042025.052025.062025.072025.082...
As per your code, Global variable gets updated based on count in the loop. However, your Application/Widget (Front end view) is not refreshed to display the updated value in Global variable.In my opinion, if you refresh for every count, it will impac...