Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try: Count({<CLIENT={"=$(vIntervalo)>500"}>}CLIENTE)
Hi Filipe,
Try this:
count( {$ < vIntervalo={">$(value)"} >}[Vehicle ID])
Thanks,
Sangram
Try: Count({<CLIENT={"=$(vIntervalo)>500"}>}CLIENTE)
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
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
Gysbert
It works! Just fix the variable (CLIENT to CLIENTE) and done!
Thank you!!
By the way great community! Fast replies.. awesome =]