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:

     

jthomson's avatar
jthomson
Solution Sage
8 years ago
wrote:


Any idea for this?

Use the ABS function as originally suggested?

JarnoVisser's avatar
JarnoVisser
Helper I
8 years ago

Sorry, made the function ABS(Measure) - 0,8 instead of ABS(Measure - 0,8). 

This works great! Thank you very much for your help.