Node Configuration Question

2.62K 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.

You are viewing 1 out of 3 answers, click here to view all answers.