Want YTD on selected date

[#1]

Hello,

           i want YTD to be calculated on Selected date by user.

for example if user select date 15 feb 2009

user should get sales of from 1 jan 2009 to 15 feb 2009

how to do it?

thanks

Harlin

[SunilChauhan]

hope this help u

sum({<MonthYear={"=$(Max(MonthYear))"}<}Amount)

[its_anandrjs]

Hi,

Use YearStart( DateField )

Rgds

Anand

[its_anandrjs]

Hi,

Use some thing like

=If ( Date >= Yearstart(Today()) and  Date <= vTest , Date )

vTest = getfieldselections( Date )

Ex:-

vTest = 15 feb 2009

HTH

Rgds

Anand

[#5]

Any correct answer in terms of Set analysis??

thanks

Harlin

[SunilChauhan]

sum({<MonthYear={"=$(Max(MonthYear))"},{Date={"<=$(=Max(date))"}}<}Amount)

what about this sardar ji

[#7]

in your statement why are u using < in the last??

{Date={"<=$(=Max(date))"}}<}

thanks

harlin

[#8]

No all above not working.

Any working example??

thanks

Harlin

[#9]

Hi Harleen,

be careful if the date is numeric or formatted like dd/mm/yyyy.

This could be the problem.

Stefano.

[#10]

Look at this

I hope this helps u

Stefano