Current month not working

[TomBond77]

Hi experts

We are working with stock measures, non-cumulative. I need to see only the stock of the current month. The following formula doesn't work. It shows the YTD value, in our case January and February. I only need to see the stocks for February. This formula seens to be ineffective:

Sum({$<MonthNum={'$(=(MonthNum)today())'}, [Product Unit]={'Cars','Bikes','Trucks'}>} [Total Stock])

Any ideas?

Thanks

Tom

[TomBond77]

I fixed it: Sum({$<Month={'$(=(month(today())))'},

But many thanks for your help, you gave me the right direction!