Using variables in a sum formula

[fabricius]

I can not get this formula to work with a variable.

I want to replace the 6 with a variable (manually set month)

Can anyone help me?

Sum({<Month={'<=6'},Year={"$(=Year(Today()))"},[Dept. No]={'820'},Project={'SKAND-820*'}>} Hours)

I have made a variable "vMonth" (see below) but it does not work.

[tresesco]

How did you try putting the variable in the expression? Like:

Sum({<Month={'<=$(vMonth)'},... ?

[kaushiknsolanki · Accepted solution]

Try this,

Sum({<Month={'<=$(vMonth)'},Year={"$(=Year(Today()))"},[Dept. No]={'820'},Project={'SKAND-820*'}>} Hours)

Regards,

Kaushik Solanki

[ankur_abhishek]

Sum({<Month={'<=$(vMonth)'},Year={$(=Year(Today()))},[Dept. No]={'820'},Project={"SKAND-820*"}>} Hours)

[fabricius]

Thanks a LOT 😉

[fabricius]

Works 🙂 Thanks a lot for your help.