topic Re: Error in set modifier ad hoc element list: ',' or ')' expected in App Development

Error in set modifier ad hoc element list: ',' or ')' expected

Anonymous — Wed, 23 May 2018 08:29:57 GMT

Hye,

I define a variable :

Set VSecondeTranche =only(if(aggr(Rank(

Count(if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1))

Count(Total if ( $(vAnnee) = ANNEE_FH and $(vTypeAnnee) = TYPE_ANNEE ,Revenu_T1))

,Revenu_T1)

,Revenu_T1)=2,Revenu_T1

)

);

That works fine when i put $(VSecondeTranche) (only 1 value).

But when i try

sum(

{$<Revenu_T1 = {'=$(VSecondeTranche) '}

>} MNT_NET_COJ_TOT

)

I've the error message.

Thanks

Re: Error in set modifier ad hoc element list: ',' or ')' expected

YoussefBelloum — Wed, 23 May 2018 08:43:59 GMT

Hi,

try this:

sum({$<Revenu_T1 = {$(VSecondeTranche)}>} MNT_NET_COJ_TOT)

Re: Error in set modifier ad hoc element list: ',' or ')' expected

Anonymous — Wed, 23 May 2018 08:55:56 GMT

same error...

Re: Error in set modifier ad hoc element list: ',' or ')' expected

sunny_talwar — Wed, 23 May 2018 08:59:12 GMT

How about this?

Sum({$<Revenu_T1 = {"$(=VSecondeTranche)"}>} MNT_NET_COJ_TOT)

Re: Error in set modifier ad hoc element list: ',' or ')' expected

Anonymous — Wed, 23 May 2018 09:03:41 GMT

no error, but it give me 0

for information, it's a title, i set

$(VSecondeTranche) & '____' &

Sum({$<Revenu_T1 = {"$(=VSecondeTranche)"}>} MNT_NET_COJ_TOT)

and it's return

Re: Error in set modifier ad hoc element list: ',' or ')' expected

sunny_talwar — Wed, 23 May 2018 09:06:37 GMT

What if you do this

Sum({$<Revenu_T1 = {"$(=$(VSecondeTranche))"}>} MNT_NET_COJ_TOT)

Re: Error in set modifier ad hoc element list: ',' or ')' expected

Anonymous — Wed, 23 May 2018 09:11:00 GMT

seems to be good !!

thanks !

Can you just explain why double quote and double $ ?

Re: Error in set modifier ad hoc element list: ',' or ')' expected

sunny_talwar — Wed, 23 May 2018 11:12:04 GMT

It depends on how the variable is declared, I am guessing your variable is without the equal sign? It just needed to be expanded, before the set analysis's dollar sign expansion. I am not completely sure if there is a sure shot way to decide this, but I usually try these two with variable and more often then not then work

1) {<FieldName = {"$(=vVar)"}>}

2) {<FieldName = {"$(=$(vVar))"}>}

Re: Error in set modifier ad hoc element list: ',' or ')' expected

Anonymous — Wed, 23 May 2018 11:51:35 GMT

ok thanks.

my variable was defines like this :

Set VSecondeTranche = ......

I'll try this next time too !!

Edit : i think i've understand. It's about the same than difference betwenn set and let in load i gess.

Re: Error in set modifier ad hoc element list: ',' or ')' expected

Anonymous — Mon, 25 Jun 2018 19:01:52 GMT

I'm getting a similar error with the following expression that aims to pull in a current AnnualProduct field selection that might include the "&" or "-" sign. It works when I select an option without one of those symbols. Any idea how to fix this?

(SUM({<AnnualYear={'$(=GetFieldSelections(AnnualYear))'},AnnualProduct={'$(=GetFieldSelections(AnnualProduct))'}>} AnnualSalesPremiumCurrentYear))