Node Configuration Question

424 views
0

Hello,

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?

Thanks,

Ric

Answered question
1

Thank you for your response. You can give this formula a try to see if this works for you

IF(node==””,calculate,node)

The above formula performs calculation for blank periods and takes the value from datasource for periods that have value.

Posted new comment

Thanks, Varoothini. That worked perfectly and is exactly what I was looking for.

0

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.

Posted new comment

Yes, I’m using ValQ Collaborate version 2.1.2.0