I am stuck on a calculation where my daily target is showing correct value however monthly target is not correct.
I am using calculation:
IF (FIRST()==0) THEN
WINDOW_sum(max([Test Qty]), 0, IIF(FIRST()==0, LAST(), 0))
Attached is the screen shot.
I want to display monthly target to be same as daily and not sum.