Post Author: Waxys
CA Forum: Formula
I am writing a report that compares data from 2007 and 2008.
The main report has a table for 2008 data and a sub report has data for 2007 data.
The issue I am having: I am comparing 3 items from a column (Example: Milk, Sugar, Eggs) If we had all 3 in 2008 then there is no issue. If we only have Milk and Sugar in 2008 but we had Milk Sugar and Eggs in 2007, only the Milk and Sugar values showed up and the Eggs are left off.
Any ides how to force a value for Eggs in 2008 of 0 so we can compare that we have not sold any eggs this year but did last year?
I hope this makes sense.