Question

Calculate between various parameters

  • 26 November 2021
  • 0 replies
  • 17 views

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!


0 replies

Be the first to reply!

Reply