GMROI Calculation

Has anyone ever made a Crystal report that calculates GMROI for each
dept/category? I am relatively new at making Crystal reports and I am having
difficulty making the report calculations.
Reply to
Jason Kelton
Loading thread data ...
Well, I've gotten somewhat closer calculating GMROI. What I do not know is how, or if, I can calculate the average inventory quantity and cost over a given period of time in Crystal. The only values I have been successful in obtaining, or using in a formula, is basically the last cost/last quantity. I would like to be able to use an average and be able to query this for a specific range of date values if possible. I can query (Select Expert) and get the GM$ no problem - it's getting an accurate avg inventory cost that is giving me problems. Any suggestions would be helpful.
Reply to
Jason Kelton
Hi Akber,
Is there a chance I could get a link to that report? My email's snipped-for-privacy@wowmontana.com. I'd also like to calculate this by dept/catg/vendor/ and if possible, by item. Thanks, Stephen
Reply to
Stephen
Akber, Did you happen to forward this report to my email? If so, could you send it again? Try this email address if the other did not work: snipped-for-privacy@birch.net
Thanks
Reply to
Jason Kelton

Site Timeline Threads

BeanSmart website is not affiliated with any of the manufacturers or service providers discussed here. All logos and trade names are the property of their respective owners.