Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try:
SUM ({<year={"$(Max(Year))"},month={"<=$(=Max(Month))"},_Flag={Inv,InvAdel}>}sum kg)
Hope this helps,
Jason
hay
thanks' but now it doesn't show anything.
do you have any idea?
yarin.
Is sum kg in square brackets, [sum kg].
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
D'oh! Thanks Jonathan!
You can try below
SUM ({<year={"$(=Max(Year))"},month=P({<year={"$(=Max(Year))"}>}MOnth},_Flag={'Inv','InvAdel'}>} [sum kg])
hope this helps