Variable Set Analysis

[#1]

I'm trying to pass a variable into my set analysis expression with no luck. This is what I'm going for:

Sum( '$(chatDate1)' [Sales])

Where my variable chatDate1 is:

'{$<dateFinal={">=$(=minDate)<$(=maxDate)"}>}'

I'm trying to keep this dynamic as I will eventually have many options that the user can select, so pasting this string into my expression doesn't seem like an efficient option.

My chart ends up not displaying any data, any suggestions?

[jaimeaguilar]

Hi,

I think it may be that you're already including single quotes in the variable,

maybe like this:

Sum( $(chatDate1) [Sales])

it will underline everything after the name of the variable, however it is just a bug of the sintax checker and it should work as expected,

regards

[#3]

Nope, it still doesn't show any data

It doesn't work if I do this either:

Sum( chatDate1 [Sales])

Without the dollar sign expansion... I honestly have no idea what I could do differently.

[Anonymous · Accepted solution]

in addition to Jaime's reply, the outer quotes in your variable expression are not necessary and you may have just included them in the post. so you don't need the single quotes in both the expressions.

[#5]

Thanks, that fixed it. I thought I had tried all possible combinations of using quotes, dollar sign expansion, etc... but I guess I missed one

[Anonymous]

no problem...been there