Reporting troubles......probably easy.
Hello forum, Hi Phil. I was hoping someone can help me with some trouble I am having with a report layout. Basically the report gives me a list of nozzles, and a total of how many of each. That works fine. I can export this to an Excel, and create an order based on a reorder calculation, minus the stock on hand. Also works fine in Excel. Doesn't want to translate for me into FM (Pro 12 Adv.)
Quick mock-up. Screenshot one shows layout mode with the fields. On screenshot 2, what appears to be happening is instead of taking the number from 'Amount in Use' from the subsummary part for the calculations, it takes the number from Trailing Grand Summary Part. Therefore all the calculations in the 'Re-Order Calc' use the same initial number.
I've been toying around with many options, but cant get it to work.
Any help would be greatly appreciated.