Forum Discussion

JarnoVisser's avatar
JarnoVisser
Helper I
8 years ago
Solved

Search for closest value

Hello,   I have a sheet with customers, sales and cumulative sales in % (sorted customers descending by sales). I want to make a measure which searches the closest value of sales for a given %. Let...
  • jthomson's avatar
    jthomson
    8 years ago

    Make a calculated column like I suggested (for 80% you'd need 0.8 rather than 0.5) called difference, then make a measure like the below:

     

JarnoVisser's avatar
JarnoVisser
Helper I
8 years ago

Hello,


I have a sheet with customers, sales per customer and cumulative sales in % per customer (sorted descending). Now I want to make a measure that finds the sales for the customer which cumulative sales is closest to a fixed value, say 50%.

 

Any idea?

 

Regards,

Jarno