Node Configuration Question
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?
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.
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.
Thanks, Varoothini. That worked perfectly and is exactly what I was looking for.
Yes, I’m using ValQ Collaborate version 22.214.171.124