Expression returns a - rather than figure expected

[#1]

Hi

I have a report I am trying to produce that shows our current stocks, packaging stocks and sales forecast.

I have setup a variable to give me current month which in my expression I divide by 4.3 to give me the forecast in weeks but for some reason it returns a -.

I've checked the link between the 2 tables and I can't see anything wrong there. If I just interrogate the forecast data I can return a figure which is correct but not using the variable.

It's going to be something simple but for the life of me I can't see what it is.

I've attached screenshots of the script and expressions etc. Any pointers in the right direction would be greatly appreciated.

Thanks Steve.

[sunny_talwar]

May be try this:

Sum({<Month = {'$(=vCurrentMonth)'}>} Forecast)/4.3

[hector_munoz]

Hi Steve,

Maybe the problem is in the set analysis of the expression... Try this expression:

Sum({$<Month={$(#vCurrentMonth)}>} Forecast) / 4.3

I hope it serves...

Regards,
H

[Anonymous]

Hi Steve,

Your Variable is called CurrentMonth but your set analysis is for vCurrentMonth.

[#5]

Sorry that didn't change anything still showing -

[#6]

Sorry that didn't change anything, still showing -

[sunny_talwar]

Can you check without the variable?/

Sum({<Month = {'$(=Month(Today()))'}>} Forecast)/4.3

[Anil_Babu_Samineni · Accepted solution]

Image showing Variable as CurrentMonth not the vCurrentMonth

Try with it

Sum({<Month = {'$(=CurrentMonth)'}>} Forecast)/4.3

Re: Expression returns a - rather than figure expected

[tresesco]

Should your variable be vCurrentMonth rather than vCurrentMonth ?

[#10]

Thanks Anil, that worked.

Regards Steve