Node Configuration Question
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
Varoothini Answered question
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.
valenzuela9 Posted new comment
Thanks, Varoothini. That worked perfectly and is exactly what I was looking for.