WTIAutomation
asked on
Can i store a formula value in crystal reports
I have the result of formula in a group footer. Can I take that result and store that value then go back up to the details and reevaluate the number? When I try it now it just reevaluates the formula for every line when I want it to just use the value from the first result.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Mimcc,
Its a formula you wrote for for the report we we're working on the last several weeks. Its the mean in that report. When I run the mean, i need to the take that value of mean in the group footer store that value and the reevaluate the lines in the details section using that value in another formula.
Reference:
https://www.experts-exchange.com/questions/27285200/How-do-I-find-the-Mean-Median-of-a-formula-in-Crystal-Reports.html
Its a formula you wrote for for the report we we're working on the last several weeks. Its the mean in that report. When I run the mean, i need to the take that value of mean in the group footer store that value and the reevaluate the lines in the details section using that value in another formula.
Reference:
https://www.experts-exchange.com/questions/27285200/How-do-I-find-the-Mean-Median-of-a-formula-in-Crystal-Reports.html
ASKER
Just to give you the latest idea of whats going on, here is a fresh version of the report with data. What I'm trying to do is compare the {recommenedStockQTY} field against the {TrxQTY} of every line and then mark it with a 1 or 0. Count the 1s and then divide that by the total number of transactions. What this will do is give me a percent of coverage, allowing me to judge then restocking quantities.
Inventory-for-Stock-production-r.rpt
Inventory-for-Stock-production-r.rpt
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
This question has been classified as abandoned and is closed as part of the Cleanup Program. See the recommendation for more details.
If the formula is the right kind it may be possible to do what you want or you could insert a subreport in the group header to get the value then use it in the detail section
mlmcc