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

[NitinK7]

Hi, 

Try below expression

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

[micheledenardi]

I believe MonthNum() is not valid function:

Try this:

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

[TomBond77]

Thanks guys

Both proposals also don't work. Any more ideas?

Regards

Tom

[micheledenardi]

Which is the format of MonthNum? 2 or 02 ? Or something else?

[micheledenardi]

if is two digits 02 you can use this:

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

[NitinK7]

Hi

Monthnum(Highlighted in red) is your field?? , if yes then could please paste here value of monthnum field

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

[TomBond77]

[micheledenardi · Accepted solution]

This should work,

be sure about the name of MonthNum or %MonthNum:

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

[NitinK7]

make sure to passing % Monthnum or Monthnum 

or you can hide % sign using below set variable in script 

set HidePrefix='%';

then load your data 

and then try below expression 

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