Removing nill values

[nick2price]

Hi, I am very new to Sage, infact 2 days into it. I do have a vast knowledge of programming though, so I am doing this to help out my company. My boss wanted to see month by month what we spend on suppliers. I think I found a report that does this, I think it was called Supplier Net spend by Month (gross) for tax year. It produces what I think it needs to display, looks quite good. One problem is though is that all suppliers are listed, even if their net spend was 0 for every month of the year. If I run a filter to remove a row which has the value field not equal to 0, it removes all suppliers from the list even if they were only 0 for 1 month.

I was essentially looking for a command or something to remove all rows from my report where every month is equal to 0. Would this be possible?

Thanks

[brucedenney]

The easy way to do this is to use a search in the supplier module to find all suppliers

WHERE "Turnover Year To Date" "Is Not Equal to" 0

This filters down the suppliers to only ones that you have had turnover with this year, then when you run the report the ones with all zeros do not show.

The problems with the "by month" reports are that they are financial months, not rolling months, so it is only the last 12 months history in the last month of the year, in the first month it is only one month and so on.