The range of values in the SetAnalisys using variables

[antonaks]

Hello everybody!

I have a problem with next expresion:

It is not works (result is 0):

sum({< first_last_name={"=sum(balance)>=$(vBonusFrom)<=$(vBonusTo)"}>} balance)

When I use form with out second condition of range all works good.

For example:

sum({< first_last_name={"=sum(balance)>=$(vBonusFrom)"}>} balance)

Show me please. Where is my mistake?

[marcus_sommer · Accepted solution]

Try it with:

sum({< first_last_name={"=sum(balance)>=$(vBonusFrom) and sum(balance)<=$(vBonusTo)"}>} balance)

- Marcus

[antonaks]

Super! Thank you very much!

[jyothish8807]

Try this once:

sum({<first_last_name= p({<$(=sum(balance))>=$(vBonusFrom)>})*p({<$(=sum(balance))<=$(vBonusTo)>})>}balance)

[antonaks]

Sorry, but this variant not working.

[jyothish8807]

No problem Just for my curiosity can you please try this one also ?

sum({<first_last_name= p({<sum(balance)>=$(vBonusFrom)>})*p({<sum(balance)<=$(vBonusTo)>})>}balance)

Br,

KC

[antonaks]

Hi!

Unfortunately not work too.

Anton.

[jyothish8807]