Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
Try this,
Sum({<Month={'<=$(vMonth)'},Year={"$(=Year(Today()))"},[Dept. No]={'820'},Project={'SKAND-820*'}>} Hours)
Regards,
Kaushik Solanki
How did you try putting the variable in the expression? Like:
Sum({<Month={'<=$(vMonth)'},... ?
Try this,
Sum({<Month={'<=$(vMonth)'},Year={"$(=Year(Today()))"},[Dept. No]={'820'},Project={'SKAND-820*'}>} Hours)
Regards,
Kaushik Solanki
Sum({<Month={'<=$(vMonth)'},Year={$(=Year(Today()))},[Dept. No]={'820'},Project={"SKAND-820*"}>} Hours)
Thanks a LOT 😉
Works 🙂 Thanks a lot for your help.