suppressing negative numbers 1

[DAUSA]

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 patient with my, I am sort of new to this.

 

[IanWaterman]

A formula can refer to a formula, it can not refer to itself.

Do you just want to suppress data.

Right click formula and select format.

In common tab you will see a formula box, selct this and enter

{@YOur Formula} <= 0

Ian

 

[DAUSA]

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 the negative dollar amounts. I have to do a summary of these numbers that do not include the negatives.

thanks for any help that can be given.

 

[DAUSA]

Disregard the last reply. You were correct Ian. That worked. Thanks again.

Dausa Clay Connell

 

[lbass]

You might want to change your original formula to:

if ({@Days Late} * .05 * {DPMORDM3.UNITPRICE} * {ASI_PURCHASE_ORDER.QTY_AUTHORIZED}) < 0 then
0 else
({@Days Late} * .05 * {DPMORDM3.UNITPRICE} * {ASI_PURCHASE_ORDER.QTY_AUTHORIZED})

Then you could insert a sum on this, assuming that {@Days Late} does not include any summaries or previous/next functions. If you use your original formula, suppressed records would contribute to your summaries (unless you used running totals that explicitly excluded negative numbers).

-LB

 

[DAUSA]

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 between damages & damages cap.
5 summarize.



Dausa Clay Connell