Concatenate variable and string in set analysis

[sibrulotte]

Hi

so my variable vBVvirtuo has 2014 in it.

I'd like to be concatenated with -12 to give 2014-12 that would be the value set in my set analysis for the field année-période financière.

This is what I had in mind:

sum({1<[Année-période financière]= {'$(=vBVvirtuo)&'-12''}>} [Montant cumulé aad])

What am I screwing up?

[#2]

Please create another variable like

vValue = Makedate(vBVvirtuo,12,1)

or

vValue = Date(Makedate(vBVvirtuo,12,1),'YYYY-MM')

Then use this value depending on [Année-période financière] values.

Thanks

[JonnyPoole]

how about this ?

sum({1<[Année-période financière]= {'$(=vBVvirtuo&'-12')'}>} [Montant cumulé aad])

[sibrulotte · Accepted solution]

Hi all,

first off, I didn't need to do a make date, but I did have to create another variable.

vBVvirtuoMM = $(vBVvirtuo)&'-12'

and in my set analysis:

sum({1<[Année-période financière]= {'$(=vBVvirtuoMM)'}>} [Montant cumulé aad])

that worked.

thanks to both of you.