If I use this expression: Sum (if (InYear ([DATE], Today(), 0), [SALES]))
against: Sum (if (InYear ([DATE], Today(), -1), [SALES]))
returns the comparison in a bar chart of the selected month in the current year against the same month last year...the issue arises when the month in the last year has no record of data. Then, the program assigns the same value for both months although, last year's value should appear as zero.
Does anyone know a way to overcome this?
Thanks in advance