Hello ,

[#1]

can anyone help me generate a formula to display data from the beginning of the year to the current selection( NOT CURRENT DATE).

ex: input data

jan- 2

feb-3

march-5

so if we select, the output should be:

jan=2

feb=5

march=10

[#2]

Try this,

set a variable like vyear = '>=' & Date(YearStart(Today())) & '<=' & Date(Today())

and in your expression, give like SUM({<Month=, Date={"$(vyear )"}>} output field name)

Make sure you have proper calendar with year, month, date...

HTH

[Anonymous]

if([DateField]>=date(yearstart(today())) and [DateField]<getselected([DateField]),[DataField],Null())

I haven't tested this but that is the logic I would start with.

[#4]

Hello Thanks for your response; but i think your solution will give till the current date; but is actuallly expected is:

if the Month: "Feb " is selected now, data should get populated only TILL FEB data ie(though we are in June, if i select FEB, data should be from Jan 1st to Feb 28th)

[#5]

the above solution will work as per your selection only.

if you select feb, it will give data from year start till feb.

have you tried the above expression??