• No replies
1 Post

Pinned topic Null values in a filed

‏2013-09-15T20:18:13Z |

Hi All,


I'm using report studio to build a simple business performance report for my client. I have following fields (Date, Device, Demand).


If I just take demand by date I get a value (say $500). If I add device also i.e device through each device by day, I get a smaller value (say $450).


I think this is because of null values in device field. I tried using coalesce function, ifelse statements but didn't help.

Did any one face this issue. Please need help. Thanks in advance :)