Hello All
I am hoping that you can help me. I am currently developing a report that is looking at stock position within a certian date range for a site\warehouse by item. This is working very well apart from one aspect. On each day I show the closing stock for that day per item and if it falls below 0 on that day then it highlights the background of the cell. What I need to do is in the last cell outside the group is denote if there ever was a closing value of 0 or less within that running value the cell says Yes, otherwise it says No.
Hopefully the screenshot below will give you some context also. All help greatly appreciated.
*This post is locked for comments
I have the same question (0)No worries. I have solved this by changing the data provider and processing it all seperately