Comparing variable to Month in expression

[Anonymous]

Hi Guys,

I'm trying to use set analysis to calculate M2D & Y2D values for some measure which should remain constant irrespective of other selections.

I'm storing the current Month, Year in separate variables defined as vYear = Year(Today()).

I have a separate field from my database which is called 'Year'.

Now, my set analysis expression looks like :

Sum({1<[Year]={'$(vYear)'}>}OOS)

However, this returns no results whereas if I output the values through KPI indicators, they both say '2018'.

If I change my variable from the function to just '2018', this works fine.

My first thought is that there is a datatype mismatch - which I have no idea how to handle in QS.

Would you be able to point what the issue is?

[juraj_misina]

Hi,

is your vYear variable defined with leading equal sign?

Juraj

[agigliotti]

let's try as below:

Sum( {1< Year = {"$(=(vYear))"} >} OOS )

hope it helps.