global filter string
tribled opened this issue · 1 comments
Hi, THX for ans! For me its more usefull than tsm!
I have tried a global filter like:
ifgte(quality, 2, ansminprice * ifgt(ansminprice, 2500g, 40, ifgt(ansminprice, 500g, 30, ifgt(ansminprice, 100g, 25, ifgt(ansminprice, 50g, 20, ifgt(ansminprice, 10g, 15, ifgt(ansminprice, 5g, 13, ifgt(ansminprice, 30s, 11, 0)))))))
/ 100)
but it doesnt work - what is wrong? ansminprice is already a custom var and is successfully working as global percent string.
if the global filter is set with the string above (remaining fields are empty), it returns wrong results.
greetings dan
You need to compare the final result to something. The final result should
be a Boolean value of either true or false.
From my estimation you would want to compare that result to percent or ppu.
It also appears you are forgetting the secondary result value for that
ifgte. Right now, it would be returning a nil value and throwing an error
if you had ui errors turned on.
Also you will want to use the % after your percent numbers, so you don’t
have to do a / 100.
…On Mon, Oct 28, 2019 at 3:17 PM tribled ***@***.***> wrote:
Hi, THX for ans! For me its more usefull than tsm!
I have tried a global filter like:
ifgte(quality, 2, ansminprice * ifgt(ansminprice, 2500g, 40,
ifgt(ansminprice, 500g, 30, ifgt(ansminprice, 100g, 25, ifgt(ansminprice,
50g, 20, ifgt(ansminprice, 10g, 15, ifgt(ansminprice, 5g, 13,
ifgt(ansminprice, 30s, 11, 0)))))))
/ 100)
but it doesnt work - what is wrong? ansminprice is already a custom var
and is successfully working as global percent string.
if the global filter is set with the string above (remaining fields are
empty), it returns wrong results.
greetings dan
—
You are receiving this because you are subscribed to this thread.
Reply to this email directly, view it on GitHub
<#7?email_source=notifications&email_token=AAB5I3O3NTWYPGG3VIJ7XT3QQ5CFVA5CNFSM4JF7NWP2YY3PNVWWK3TUL52HS4DFUVEXG43VMWVGG33NNVSW45C7NFSM4HU343MQ>,
or unsubscribe
<https://github.com/notifications/unsubscribe-auth/AAB5I3NJ2OFBP4QH675ESX3QQ5CFVANCNFSM4JF7NWPQ>
.