3 Replies Latest reply on Jul 9, 2018 9:17 AM by Jim Dehner

    Finding closest value in a table for a parameter

    Adam Kastan

      Hi,

       

      In the attached workbook I have a table of contracts for a customer with pricing dependent of how much bandwidth is ordered. I am trying to create a cost forecast by using a parameter (Projected BW). Some contracts do not have the parameter value and I want to find the next closest and higher value per contract. An example would be if the Projected BW parameter = 300 for contract DEF02 how can I return the cost for Bandwidth of 400 which would be $2,200 in sheet 1 for the measure PROJECTED COST PER SITE?

       

             

      CONTRACT_IDBANDWIDTHCOSTAAV_TECHREGIONMASTER_VENDOR_NAMESITE_CNT
      DEF0210010001.95WESTDEFCON5
      DEF0220014001.95WESTDEFCON5
      DEF0240022001.95WESTDEFCON5
      DEF0250024001.95WESTDEFCON5
      DEF0275032751.95WESTDEFCON5
      DEF02100037001.95WESTDEFCON5

       

      Thanks for your assistance.

      Adam