Variance Percentage formula is showing #error if there is no Data
Summary:
Hi Folks,
I have added Variance Percentage formula to the form and I'm doing actual and forecast variance %. But it is showing #error when there is no data. How to handle it.?
If Forecast don't have data also that time it is blank.
Content (please ensure you mask any confidential information):
Version (include the version you are using, if applicable):
Code Snippet (add any code snippets that support your topic, if applicable):
Formula given as
Tagged:
0