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 :)