web
You’re offline. This is a read only version of the page.
close
Skip to main content
Community site session details

Community site session details

Session Id :
Microsoft Dynamics AX (Archived)

Checking if a RunnngValue within a group ever dropped below 0

(0) ShareShare
ReportReport
Posted on by 110

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)
  • Verified answer
    Otis Ranger Profile Picture
    110 on at
    RE: Checking if a RunnngValue within a group ever dropped below 0

    No worries. I have solved this by changing the data provider and processing it all seperately

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1
Community Member Profile Picture

Community Member 4

#2
Guy Terry Profile Picture

Guy Terry 2 Moderator

#2
Nayyar Siddiqi Profile Picture

Nayyar Siddiqi 2

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans