Date variable in a expression

[massimo6919]

I have this expression with a costant limit :

SUM(if(data<= '15/01/2014' ,SALDO,0))

if i want to insert a date store in a variable genn_data i wrote

sum(  {$<data<=$(genn_data)>} SALDO)

but don't return the same value. What is wrong ?

[alexandros17]

Ciao Massimo,

prova così:

sum(  {$<data={'<=$(=genn_data)'}>} SALDO)

se ancora non funziona prova ad inserire al posto della variabile una data nel tuo formato e verifica cosa accade.

Fammi sapere

[#3]

vai massimo che ce la fai

[massimo6919]

Non funziona ancora .. se metto la data fissa mi restituisce 0

[#5]

dipende dalle impostazioni di date del tuo sistema operativo.

devi cercare di uniformarti a questo aspetto secondo me.

non riesci a allegare qualcosa?

[massimo6919]

Allegato!

[mangalsk · Accepted solution]

Hello,

Kindly find the attachment where

I have changed variable

genn_data=='15/01/'&ANNO

and expression to SUM(if(data<= genn_data ,SALDO,0))

Now its giving correct value if year 2014 selected.

Regards,

Mangal

[#8]

is too static: if he doesnt want to select 2014??

[#9]

Create variables for both Year and Month

Year =Max(Year)

Month=Max(IF(Year=$(Year),MonthNum))

Like this you can make it dynamic

By default the variables will hold max year and maxyear's corresponding max monthnum

and if any selections made from those selections the va riables will change accordingly.

[mangalsk]

Hiee,

Its not static.

Select any year it will give corresponding value.

Try any year selection

[#11]

I meaned that if u select that field (YEAR) then this can impact with other sheets and selections: the use of variables seems to be better in my opinion, so u can select the year having a value of the expression corresponding to what u prefer