Target values till date

[#1]

Hi all,

I have scenario where i am calculating sales vs target

example: current year sales/current year target

I have target values all the days in the year but i have sales up to today, So i want current year sales up to date and target value also up to date.

thanks in advance

[MK_QSL]

This will depend on how you have target... i.e are your target monthly or daily?

[#3]

daily targets i have

[MK_QSL]

SUM({<Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Target)

and

SUM({<Date = {">=$(=YearStart(Today()))<=$(=Today())"}>}Actual)