I have several parameters for a same calculation that i want looker to do in a single row. For example:
If 1 < Value > 50 then calculate 1%
If 51 < Value > 100 then calculate 0,8%
If 101 < Value > 200 then calculate 0,5%
I want looker to find where the value is and then calculate the % that`s correct and show it in one row (it keeps showing a row for each parameter).
This is as far as i could go. haha
if(${partner_config.tiers_limit_type}="TX Amount" ,
${partner_config.processing_fee_lcy_fix} + ${transaction_detail.amount}*(${partner_config.processing_fee_lcy_percentage}/100),
if(${transaction_detail.amount}>${partner_config.processing_fee_lcy_min}AND${transaction_detail.amount}<${partner_config.processing_fee_lcy_max},${transaction_detail.amount}*(${partner_config.processing_fee_lcy_percentage}/100),
if(${partner_config.tiers_limit_type}="# Transactions", ${partner_config.processing_fee_lcy_fix},
if(${partner_config.tiers_limit_type}="Ticket average",-99,-1))))
Is this possible? Thanks!