Calculated Column Error in BAQ

[Rick_Bird]

@ckrusen

a + b + c = null a - b = null a * b = null a / b = null b / a = null

YES:

[Chris_Conn]

+1 for visual examples. Despite your profile saying OH, I am convinced you are from the Show Me State

[Mark_Wonsil]

@Chris_Conn

Despite your profile saying OH

@Rick_Bird is very involved in MI-IN User Group (hey @ERPSysAdmin and @Beth!!!). If MI can tolerate him, he’s cool.

[A.Baeisa (Al)]

(case when
((YTDSales4.Calculated_YTDSales4) is null
OR (YTDSales3.Calculated_YTDSales3) is null
OR YTDSales3.Calculated_YTDSales3=0)
then 0
else
((YTDSales4.Calculated_YTDSales4-YTDSales3.Calculated_YTDSales3)/YTDSales3.Calculated_YTDSales3)
end)