Forum Discussion
Grand total varies depending on fields used in Rows
Hi Miguel,
Thank you for your reply. I can appreciate that it's difficult to solve this without being able to see the model set-up! The date column does come from the same table, so I assume that it can't be related to model set-up.
I checked the 'Show items without data' and it didn't appear to make a difference. And I checked the source data in our data warehouse and there don't appear to be any null values.
So thank you for you help with this but I appreciate it might be difficult to do anything further on this!
Many thanks,
Stuart
Hi Stuart,
As refered without any additional information it's rely hard, context transiction may be happening that it may not realize on the images you provide.
If you want to send some more details on this you can send me a PM and we can try and check this.