ytd - how can do it ?

[Anonymous]

hai    

i have 3 feilds: 1 - year 2 - month 3 - sum kg

i want to calculate the ytd for the "sum kg".

i uesed :

SUM ({<year={'$(vMaxYear)'},month={'<=$(vmaxMonth)'},month=>}{$<_Flag={Inv,InvAdel}>}sum kg

)

but it's show me only the current month.

how can i do it?

thanks'

yarin.

SUM({<year={'$(vMaxYear)'},month={'<=$(vmaxMonth)'},year=>}{$<_Flag={Inv,InvAdel}>}sum kg

[Jason_Michaelides]

Try:

SUM ({<year={"$(Max(Year))"},month={"<=$(=Max(Month))"},_Flag={Inv,InvAdel}>}sum kg)

Hope this helps,

Jason

[Anonymous]

hay

thanks' but now it doesn't show anything.

do you have any idea?

yarin.

[Jason_Michaelides]

Is sum kg in square brackets, [sum kg].

[jonathandienst]

Yarin

Assuming everything else is correct, I suggest that you try this:

SUM ({<year={"$(=Max(Year))"},month={"<=$(=Max(Month))"},_Flag={'Inv','InvAdel'}>} [sum kg])

(Courtesy Jason, with some minor grammatical fixes)

Hope that helps

Jonathan

[Jason_Michaelides]

D'oh! Thanks Jonathan!

[SunilChauhan]

You can try below

SUM ({<year={"$(=Max(Year))"},month=P({<year={"$(=Max(Year))"}>}MOnth},_Flag={'Inv','InvAdel'}>} [sum kg])

hope this helps