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
![](https://secure.gravatar.com/avatar/0eb1f43f086e4dd9ed250186df16b645?s=30&d=https%3A%2F%2Fcommunity.valq.com%2Fwp-content%2Fuploads%2Fap_avatars%2F8c19f571e251e61cb8dd3612f26d5ecf.jpg&r=g)
Thanks, Varoothini. That worked perfectly and is exactly what I was looking for.