This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
@benakesh, thanks for the help..but this is giving the same output as earlier..
when you see the the blue circle its jumping from KC03RW300-1 to KC03RW300-3(for us this is considered the same location since lat and long are same for this location, we need to avoid this and select the one apart from the same location and that location shoud be within 3 miles. Please see attached..please pardon my drawing ..example..here if KCRW302-3. is within 3 miles of KCRW300-1 should jump to KCRW302-3.
Hi @benakesh ..thats great It worked in most of the cases but ..some of the results still looks the same since.."no jump" is only the string we are entering in formula but in practical can it jump to the other cascade like the one in blue circle or can we restrict the jump value (in this case RF utilization 1900) to less than 60%(the value here is 64.22 in blue).
Hi @benakesh is that possible to use the Multi formula or any other formula where we can consider only 20 rows and find the minimum of that instead of distance within 3 miles for now then later we will consider distance.. and replace the Null value coming out of the first formula...I tried to use Multi row formula with Row-10 it is considering 10th row..I need to see "within" 10 rows.