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 Chris Miller 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: *

  1. heidik

    Formula returns zero value when record does not meet criteria

    There is no grouping on the report. Every field is a formula field. The formula names are in parentheses below. (mo-5) (mo-4) (mo-3) (mo-2) (mo-1) (mo) 2002 2002 2002 2002 2002 2002 Dec Jan Feb Mar Apr May (pln-1)...
  2. heidik

    Formula returns zero value when record does not meet criteria

    The plan table is detailed above. The roll up table has: Peyr | Year |Func | BUCO| DVCO | Type | cust type | cust | mth 4 | 2003 | QCPP | EMNA | GRDH | AUTO | Internal | CH | 21 4 | 2003 | QCPP | EMNA | GRDH | AUTO | | | 73 4 | 2003| QCPP|...
  3. heidik

    Formula returns zero value when record does not meet criteria

    Here is the basic idea of the report. We have created a data base to store our CPPM data. There are a total of 3 tables. One table with plan (referenced above), one with detail data and one with monthly roll up data. The roll up data is calculated and stored (roll ups such as customer...
  4. heidik

    Formula returns zero value when record does not meet criteria

    I've changed the formula like you suggested and it no longer prints zero; it's blank. The month and year are still printing. 2002 2002 2002 2002 2002 2002 Dec Jan Feb Mar Apr May 20 2002 2002 2002 2002 2002...
  5. heidik

    Formula returns zero value when record does not meet criteria

    Should return nothing. I'll include a simple example and hopefully I'm just missing something! The report needs to have current month and the previous 11 months. Here is my formula. My parameter input for current month is 5, report year = 2003 and division = GRDH // initialize month/year...

Part and Inventory Search

Back
Top