Calculate between various parameters

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).

05e6d212-4e6b-49e0-a2e0-89b176403e06.png

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!

0 0 69
0 REPLIES 0
Top Labels in this Space
Top Solution Authors