Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am using set analysis with a variable but cannot get the syntax to work - being trying on and off for days !
The variable TUE_P_PGR has the value (54,999,51).
This works fine...
if(
(only( {<PGR={54,999,51}>} PGR ))>0 ,
sum({<BRANCH={86,96}>} REQ)
but this doesn't below and I cant find any combo of '$({" that seems to produce the same result..
if(
(only( {<PGR={$(=(TUE_P_PGR))}>} PGR ))>0 ,
sum({<BRANCH={86,96}>} REQ)
Any ideas appreciated please 🙂 !!
Aha - this finally worked below - thank you for your help though it gave me some ideas !
If(Only({$<PGR = {$(=TUE_P_PGR)} >} PGR) > 0,
Sum({<BRANCH = {86,96}>} REQ))
Try this
If(Only({<PGR = {"$(=TUE_P_PGR)"}>} PGR) > 0, Sum({<BRANCH = {86,96}>} REQ)
or
If(Only({<PGR = {"$(=$(TUE_P_PGR))"}>} PGR) > 0, Sum({<BRANCH = {86,96}>} REQ)
The below can also work
If(Only({$<PGR = {'$(TUE_P_PGR)'} >} PGR) > 0, Sum({<BRANCH = {86,96}>} REQ)
Hi Both,
Thanks for your input but neither worked I am afraid. Any other thoughts please ?
Thanks
Aha - this finally worked below - thank you for your help though it gave me some ideas !
If(Only({$<PGR = {$(=TUE_P_PGR)} >} PGR) > 0,
Sum({<BRANCH = {86,96}>} REQ))