NaN Errors

If data or other circumstances cause the Calculated Column's expression to attempt a "division-by-zero", the resulting value in the datalayer will be NaN, which stands for "Not a Number". This can cause problems or be confusing when the data is visualized.

If this kind of result is possible, then you may want to wrap your expression in an IIF function in order to provide an alternative to the NaN result in the data. For example, the expression

IIF(@Data.RoomsAvailable~ <> 0, @Data.RoomRevenue~/@Data.RoomsAvailable~, "")

tests to see if a division by zero is going to happen and, if so, instead of doing the calculation, supplies an empty value in the datalayer.