No I did not use running totals yet. As you can tell this is way over my head.
I will try what you suggested above to see if that will work.
Here is my overall task.
1. The formula for damages.
2. A formula for damages cap.
3. If damages < 0 then no damages
4. Then choose the less amount...
Thanks Ian for your help. I am still having problems. So here are the details.
My first formula is ({@Days Late} * .05 * {DPMORDM3.UNITPRICE} * {ASI_PURCHASE_ORDER.QTY_AUTHORIZED})
This formula brings back the following examples;
-20,428.90
-18,465.40
4,508.80
What I am trying to do is Hide...
So here is the down low.
I built a report that has formula's that put some numbers into a negative. The want to show all amounts except those that are negative. When I have tried to create this, I get a error saying Formula cannot refer to formula. Does anyone have any suggestions. Please be...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.