Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: DAUSA
  • Order by date
  1. DAUSA

    suppressing negative numbers

    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...
  2. DAUSA

    suppressing negative numbers

    Disregard the last reply. You were correct Ian. That worked. Thanks again. Dausa Clay Connell
  3. DAUSA

    suppressing negative numbers

    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...
  4. DAUSA

    suppressing negative numbers

    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...

Part and Inventory Search

Back
Top