I have a calculation which considers YTD logic which shows value, but randomly sometimes values get off and shows zero(which actually has some values) .
Without knowing the root cause and as a solution, I ask admin team to delete the .shared file and refresh the task. And it resolves my issue for that time being. But the issue happens regularly which bothers the users.
Has anyone faced this weird kind of issue? do you have any permanent solution to this issue?
I don't believe, The main reason may get off is there must be not having values on that filter. Could be only one reason is that. Can you try using Table box for testing and let us know to find the root cause
Before develop something, think If placed (The Right information | To the right people | At the Right time | In the Right place | With the Right context)