Topic
  • No replies
santum
santum
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 :)

Santosh.