Set Analysis - Using variables for comparison

[#1]

Hello,

I'm trying to use variables on a count aggregation but it's not working

COUNT({< vIntervalo = {'>500'}>}CLIENTE)

when vIntervalo is SUM({<MOTIVO ={ 'NOR'  }>} VALOR_BX )

My goal is to show the CLIENTE (customers) counting that vIntervalo (sales) is bigger than 500.

I've been triend many syntaxes and also created a second variable with 500 content.

Appreciate any help.

Tks

[reddy-s]

Hi Filipe,

Try this:

count( {$ < vIntervalo={">$(value)"} >}[Vehicle ID])

Thanks,

Sangram

[Gysbert_Wassenaar · Accepted solution]

Try: Count({<CLIENT={"=$(vIntervalo)>500"}>}CLIENTE)

[#4]

Hello Sangram,

thanks for reply but it didn't work. Actually it is adding the whole value like without filtring {">$(500)"}

count( {$ < vIntervalo={">$(5000)"} >}CLIENTE)

maybe I could try to don't use variable but don't know the correctly sintaxe.

Tks anyway

[#5]

Hello Gysbert

thanks for reply but it also didn't works. Actually it is adding the whole value like without filtring {"=$(vIntervalo)>5000"}

Count({<CLIENT={"=$(vIntervalo)>5000"}>}CLIENTE)

maybe I could try to don't use variable but don't know the correctly sintaxe.

Tks anyway

[#6]

Gysbert

It works! Just fix the variable (CLIENT to CLIENTE) and done!

Thank you!!

By the way great community! Fast replies.. awesome =]