need to put variable on value till today

[yadav_anil782]

Dear Comunity,

i have data in table year 2010 to year 2016  but i want to represent data only till sysdate mean till today so i'm puting this script in expresion but its not working plz suggest how to use vtoday variable in this script

=sum(COMPONENT_AMOUNT)<=vtoday

[sunny_talwar]

May be this:

If(DatabaseYearFieldName <= Year(Today()), Sum(COMPONENT_AMOUNT))

[Kushal_Chawda]

Try with set analysis

=Sum({<Year = {"<=$(=year(today()))"}>}COMPONENT_AMOUNT)

[Anonymous]

Anil,

try this one..

=sum({<DateFieldName={"<=$(=date(today(), req format)))"}>} Component_Amount)

[jonathandienst]

In script, filter out data withe dates after today as:

LOAD ...

FROM ...

WHERE myDateDateField <= Today();

or

SQL SELECT ...

FROM ...

WHERE myDateDateField <= '$(vtoday)';  

The actual script depends on how vtoday is defined....

In expressions in the front end

Sum(If(myDateField <= '$(vtoday)', amount))

Sum({<myDateField = {"<=$(=vtoday)"}>} amount)

Again, the exact syntax depends on how vtoday is defined.

[jsingh71]

See this

[#7]

Try the below expression @Anil

=sum({<Date = {"<=$(=today())"}>}COMPONENT_AMOUNT)

[yadav_anil782]

Thanks Balraj