Forum Discussion
Calculated fields show #Error when placed on Report Builder report.
I hope this is the right forum. This is the forum that comes up when I click the "Forum" button in Report Builder. I am finding that the most basic calculated fields show #Error when placed on a ...
It's hard to say what you are doing wrong, there is not enough detail here. How are you placing the field onto your report - is it in a single text box or in a table?
If it's in a table it should work since calculated fields are calculated once per row. If you have just dragged on a text box it depends how you are aggregating the calculated field. In the example calculation you've given you are returning a string so you would need to use something like a First() or Last() aggregate, not one of the mathematical ones like Sum()
If I add a field like the one you've shown
It works fine if I use it in a table output