set analysis expression

[#1]

is this set expression is fine??

sum({$<Year = {$(vCurrentYear)},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Thanks

[PrashantSangle]

Hi,

use "

like

sum({$<Year = {"$(vCurrentYear)"},newDueIndicator={"3. Due Later"}>} [Undelivered Net value USD])

Regards

[SunilChauhan]

its seems ok to me.it should work

[its_anandrjs]

The SET expression looks ok or you can try

sum({$<Year = {" $(vCurrentYear) "},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

[#5]

not working,getting blank only.

[SunilChauhan]

you should try this one also

sum({$<Year = {$(=Year(Today()))},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

[ashfaq_haseeb]

Try this

sum({$<Year = {"$(=vCurrentYear)"},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Regards

ASHFAQ

[its_anandrjs]

Or you can try

sum({$<Year = {' $(vCurrentYear) '},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Or

sum({$<Year = {' $(=YearStart( Today()) ) '},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Or

sum({$<Year = {' $(Year(vCurrentYear)) '},newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

Or may be you Year value is not in proper format please check that.

Regards,

Anand

[jagan]

Hi,

Try this expression

sum({$<Year = {2014}, newDueIndicator={'3. Due Later'}>} [Undelivered Net value USD])

If you are getting value for this, then there is an issue with your varaible.

Regards,

Jagan.

[adiarnon · Accepted solution]

hi,

check that in your expression of the variable -vCurrentYear

you have = before the expression