Node Configuration Question

4.29K 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

2 Answers

1
116 1 Comment

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
valenzuela9 commented

Thanks, Varoothini. That worked perfectly and is exactly what I was looking for.
0
116 1 Comment

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
valenzuela9 commented

Yes, I’m using ValQ Collaborate version 2.1.2.0
83 Questions total questions asked
23 Solved total solved questions
104 Answers total answer posted
4646 Total users total community members