using variable in expresion

[lukas_sokol]

Hi,

I have the following problem

I have variable vUserCompanyCode with store  company  codes (loaded from excel) for specifed user

I have sample expresion below ( working)

sum( if( WildMatch(CompanyCode, 10,20,25,30) , NetSales))

but when i use variable ( the result is emty), variable have the same value (10,20,25,30)

sum( if( WildMatch(CompanyCode,$(vUserCompanyCode)) , NetSales))

Regards

Łukasz

[lukas_sokol]

vUserCompanyCode is dynamic variable, so I can't assing values directly

if  I have more than one Company code in variable  thats not working.

[lukas_sokol]

If in the set analysis I add condition

and  WildMatch(CompanyCode, 10,20, 30)    --this is ok

if i use variable $(vUserCompanyCode)

when variable $(vUserCompanyCode) = 10

and  WildMatch(CompanyCode, $(vUserCompanyCode))  --this is ok

when variable $(vUserCompanyCode) = 10,20,30

and  WildMatch(CompanyCode, $(vUserCompanyCode)) --this is NOT ok

[#4]

Hi,

This should do the trick:

sum({$<  $(='CompanyCode= {' & $(vUserCompanyCode)  & '}') >}NetSales)

Best regards,

Daniel

[tamilarasu · Accepted solution]

No. The vUserComnayCode variable looks fine. You need to change the expression as sum( {<CompanyCode={$(=vUserCompanyCode)}>} NetSales).. Since you are using formula in your vUserCompanyCode. If the above one not work, then try with '$(vUserCompanyCode)'.. Let me know..

[tamilarasu]

You can also try like

Sum({<CompanyCode={"$(=$(vUserCompanyCode))"}>} NetSales)

[lukas_sokol]

Than's evryone for help

The below expression works fine

sum({<CompanyCode={$(=vUserCompanyCode)}>} FakturabeloppBase)

but one more thing, definition of vUserCompanyCode must start with "="

Regards

Łukasz