Selection

[MauriceLudo]

Bonjour,

pourriez-vous s'il vous plait m'explique pourquoi qd je sélectionne G1000 de dimension RU, j'ai les autres RU que s'affiche.

ci-joint copie écran, merci d'avance .

[sunny_talwar]

Seems like two of your expressions are using set analysis to ignore selection in RU field

[MauriceLudo]

thanks Sunny

Here expression

1- if(Dimensionality()=2 or Nature_S='Collect',

sum({$< YearS={"=$(=Max(YearS))"}, MonthS={"<=$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)

2-

if(

Nature_S='Collect',

[Actuals N YTD ERP] - [Actuals N YTD SMART],0

)

[sunny_talwar]

You expressions look good to me, would it be possible to share a sample of your application to check it out?

[MauriceLudo]

voila

[MauriceLudo]

voila

[sunny_talwar]

When I try to open this, it is showing me 'access denied' error. Do you have section access?

[MauriceLudo]

yes there was an access section,here without access section

[sunny_talwar]

I think you were using alternate state and you used $ in your expression instead of SMART:

if(Dimensionality()=2 or Nature_S='Collect',

sum({$< YearS={"=$(=Max(YearS))"}, MonthS={"<=$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)

if(Dimensionality()=2 or Nature_S='Collect',

sum({SMART< YearS={"=$(=Max(YearS))"}, MonthS={"<=$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)

[sunny_talwar · Accepted solution]

Alternatively, this should also work:

if(Dimensionality()=2 or Nature_S='Collect',

sum({<YearS={"=$(=Max(YearS))"}, MonthS={"<=$(=Max(MonthS))"} >}ACTUALERP_S/Weight )

)