
1. Re: Finding the next highest value in a table
Aiswarya Sundaram Jul 8, 2016 2:32 PM (in response to Adam Kastan)Hi Adam,
This should help:
IF ISNULL(ATTR([PRICING_TABLE (DUKENET)].[Ethernet Bw Start])) then
if SUM([Mbps])<=10 then 10
ELSEIF SUM([Mbps])>10 and SUM([Mbps])<=20 then 20
ELSEif SUM([Mbps])>20 and SUM([Mbps])<=50 then 50
ELSEIF SUM([Mbps])>50 and SUM([Mbps])<=100 then 100
ELSEIF SUM([Mbps])>100 and SUM([Mbps])<=200 then 200
ELSEIF SUM([Mbps])>200 AND SUM([Mbps])<=400 THEN 400
END
ELSE SUM([Mbps])
END
Since the MBPS field is also linked in the blending, it resulted in a NULL where it didn't match, I made use of that.

2. Re: Finding the next highest value in a table
Adam Kastan Jul 11, 2016 8:11 AM (in response to Aiswarya Sundaram)Hi Aiswarya,
Thanks for your reply. I did not provide a full enough example of my question and your response, while correct, will not work with the fuller dataset I use. I have over 1K+ contracts and 50K+ sites in my dataset. I have updated the workbook with additional contracts and sites to provide a more robust example of my question.
Thanks,
Adam

TELCO.twbx 55.6 KB
