Recent content by sch9009

so I have been researching for a while and still can't correctly fix this issue. So now I turn to the boards. In short, I want to be able to have the report return any items that have an amount that falls within a specific range. I add up the total amount of one item for one month, and I...

I need to right a formula that will give me an average of how many PO's are being generated per minute. What am I looking to do? I tried doing start time - end time/number of PO's, but this doesn't seem correct. Thanks

thanks man. I will try this now. What do you recommend I do besides nested formulas? I have been working with crystal for about 2 and a half years. I'm sort of a scrappy worker, so if I get it to work, I do it. But I am all about being more efficient.

@3 Day Average = ROUNDUP({@Daily Average}*3,0) @ 5 Day Max = ROUNDUP({@Daily Average}*5,0) @ Convert to Par UOM = IF {ITEMMAST.ALT_UOM_01}={ITEMLOC.UOM} THEN (Sum ({@Lowest UOM Quantity}, {ITEMLOC.ITEM}) / {ITEMMAST.ALT_UOM_CONV_01}) ELSE IF {ITEMMAST.ALT_UOM_02}={ITEMLOC.UOM} THEN (Sum...

Formula that I am trying to group by or summarize (i.e. count if..) @par analysis= IF {ITEMLOC.REORDER_POINT}<{@3 Day Average} then "UP PAR" else IF {ITEMLOC.REORDER_POINT}>{@5 Day Max} then "REDUCE PAR" else "SUFFICIENT PAR LEVEL" For the formulas that make "@Par analysis" work @3 Day...

So I know that with crystal you can summarize on said summaries.. but I have read about work arounds, but trying to apply to my situation. First let me explain the basis of my report: This report shows items that are in a supply room. With a lot of formula, it suggests what "Par Level" an...