Why do I get "error in formula" message in a Report DataPage?
Question:
Why do I get "error in formula" message in a Report DataPage?
Answer:
There could be a number of arithmetic issues contributing to this error, but one common situation is when your formula is causing division by zero.
Example: "A/B" works fine, except when B is zero and you get the error message.
To solve this situation you can use the following code which catches the zeros before they cause an error. Just make sure to change A and B with you own field names.
Case
When [@field:B]= '0'
Then null
Else
([@field:A]/[@field:B])
End
