There has already been a few posting around problems with nulls in calculations.
Has anyone found a way to replace a null with a zero?
I am yet to find a way to calculate against an inserted zero after trying:
case
when [Hours Worked] is null then 0
when [Hours Worked] is null then '0'
when [Hours Worked] is null then ('0')
when [Hours Worked] is null then [Zero] (where [Zero] is a Data Item with value 0)
when [Hours Worked] is null then cast('0',integer)
when [Hours Worked] is not null then [Hours Worked]
end
Some will cause errors, while others will not error but not calculate (treating [Hours Worked] as 0).
Ideas?
Thanks, Andrew