Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
could you help me with my variable, which I need to use in set analysis
variable:
vDistrict=Concat(DISTINCT chr(39)&Dim_LT&chr(39),',')
My variable has values:
Expression return 0, but it is wrong result:
Sum({< Fakt = {'Fakt_1'}, Rok = {'$(vRokDND)'}, [District] = {'=ValueList($(vDistrict))'} >}[#Reg])
Thank you
Thanks, you were partly right, the ValueList is useless, but there was still a problem with quotes that shouldn't have been there. This is how it should be right:
Sum({< Fakt = {'Fakt_1'}, Rok = {'$(vRokDND)'}, [District] = {$(vDistrict)} >}[#Reg])
Hi,
Sum({< Fakt = {'Fakt_1'}, Rok = {"$(=vRokDND)"}, [District] = {"$(=vDistrict)"} >}[#Reg])
Maybe this one ?
Regards
Thanks, you were partly right, the ValueList is useless, but there was still a problem with quotes that shouldn't have been there. This is how it should be right:
Sum({< Fakt = {'Fakt_1'}, Rok = {'$(vRokDND)'}, [District] = {$(vDistrict)} >}[#Reg])
OH you're right my bad ! Glad to know it's working fine.