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