Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I've made a class function with limit of intervals:
=if(IMEI_SALE.DEALER_PURCHASE_PRICE_NET > 3000 , '3000 +', Class(IMEI_SALE.DEALER_PURCHASE_PRICE_NET,800, 'PRICE'))
The problem is that the last interval from class function is from 2400 to 3200 while in reality is from 2400 to 3000. Is there any way to correct the value 3200 to 3000?
Try:
= if(IMEI_SALE.DEALER_PURCHASE_PRICE_NET > 3000 , '3000 +', Class(IMEI_SALE.DEALER_PURCHASE_PRICE_NET,
if(IMEI_SALE.DEALER_PURCHASE_PRICE_NET>= 2400, 600, 800), 'PRICE'))
But better would be to use '3200 +' or to change the interval-size to 750 - it's more logically.
- Marcus