Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi there,
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
Can you post your qvw here? May be with reduced data.