I’m working on a complex dashboard where I have several If-Then scenarios coming from demand consumption. The dashboard is pulling information from Job Demand and Issued figures, On-Hand demand, and Open PO Lines. In a case where the demand is satisfied in the job, I don’t want it to show the On-Hand, nor PO information. If it’s still an open line item and is Satisfied by On-Hand Material then I don’t want it to show the Open POs for that part. I also need to tackle the issue that if there is more than one On-Hand location and/or multiple POs that it not duplicate the demand figures in each line. Is there a way to either tackle this kind of logic in the BAQ output or the Dashboard information? I would prefer to show a single line for the demand and and supply portions (skipping what is not needed) and be able to drill down into the detail as needed.
Already have an account? Login
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.
Sorry, we're still checking this file's contents to make sure it's safe to download. Please try again in a few minutes.
Sorry, our virus scanner detected that this file isn't safe to download.