I have a node that is setup as Datasource in Configuration. This allows me to pull in the actuals when I refresh the datasource. However, for the remaining months, I would like to calculate those amounts. What is the recommended setup for this?
Thank you for your response. You can give this formula a try to see if this works for you
The above formula performs calculation for blank periods and takes the value from datasource for periods that have value.
Firstly, may I know if you are using the ValQ Collaborate visual?
It will be mentioned on hover over the visual like below:
This detail will be helpful in suggesting a solution.