Calculate distance between two points (numbers) in a number line

S

Silvio

Hello everyone, how can I calculate the distance between two points (numbers)
in a number line using a calculated field? For example: (Filed1 and Filed are
saved number in any combination of positive and negative numbers)

Filed1 = -10
Field2 = +15
Number distance = 25 (this is the correct result)

Example 2:
Filed1 = -10
Field2 = -5
Distance = 5 (this is the correct result)

Example 3:
Filed1 = -10
Field2 = 5
Distance = 15 (this is the correct result)

This is what I have done but it does not work with combination of negative
and positive numbers...

=(IIf(([Filed1]>[Filed2]),Abs([Filed1])-Abs([Filed2]),([Filed2]-[Filed1])))
 
T

Tom Lake

Silvio said:
Hello everyone, how can I calculate the distance between two points
(numbers)
in a number line using a calculated field? For example: (Filed1 and Filed
are
saved number in any combination of positive and negative numbers)

Filed1 = -10
Field2 = +15
Number distance = 25 (this is the correct result)

Example 2:
Filed1 = -10
Field2 = -5
Distance = 5 (this is the correct result)

Example 3:
Filed1 = -10
Field2 = 5
Distance = 15 (this is the correct result)

This is what I have done but it does not work with combination of negative
and positive numbers...

=(IIf(([Filed1]>[Filed2]),Abs([Filed1])-Abs([Filed2]),([Filed2]-[Filed1])))
Click to expand...

Why not just do

=Abs([Filed1] - [Filed2])

(did you mean Field1 and Field2?)

Tom Lake
 
S

Silvio

Thanks Tom, easy enough. I hope this is just my *Monday* brain breakdown.
(Yes I ment Field1 and Field2).

Tom Lake said:
Silvio said:
Hello everyone, how can I calculate the distance between two points
(numbers)
in a number line using a calculated field? For example: (Filed1 and Filed
are
saved number in any combination of positive and negative numbers)

Filed1 = -10
Field2 = +15
Number distance = 25 (this is the correct result)

Example 2:
Filed1 = -10
Field2 = -5
Distance = 5 (this is the correct result)

Example 3:
Filed1 = -10
Field2 = 5
Distance = 15 (this is the correct result)

This is what I have done but it does not work with combination of negative
and positive numbers...

=(IIf(([Filed1]>[Filed2]),Abs([Filed1])-Abs([Filed2]),([Filed2]-[Filed1])))
Click to expand...

Why not just do

=Abs([Filed1] - [Filed2])

(did you mean Field1 and Field2?)

Tom Lake
Click to expand...
 
D

Damon Heron

=IIf(([filed1]<0 And [filed2]<0) Or ([filed1]>0 And
[filed2]>0),([filed1]-[filed2]),(Abs([filed1])+Abs(([filed2]))))

Thats provided filed1 (field1??) or filed2 are not = 0.

Damon
 
D

Damon Heron

I just had one of those DUH moments - Tom Lake gave me a wake-up call.

Damon

Damon Heron said:
=IIf(([filed1]<0 And [filed2]<0) Or ([filed1]>0 And
[filed2]>0),([filed1]-[filed2]),(Abs([filed1])+Abs(([filed2]))))

Thats provided filed1 (field1??) or filed2 are not = 0.

Damon

Silvio said:
Hello everyone, how can I calculate the distance between two points
(numbers)
in a number line using a calculated field? For example: (Filed1 and Filed
are
saved number in any combination of positive and negative numbers)

Filed1 = -10
Field2 = +15
Number distance = 25 (this is the correct result)

Example 2:
Filed1 = -10
Field2 = -5
Distance = 5 (this is the correct result)

Example 3:
Filed1 = -10
Field2 = 5
Distance = 15 (this is the correct result)

This is what I have done but it does not work with combination of
negative
and positive numbers...

=(IIf(([Filed1]>[Filed2]),Abs([Filed1])-Abs([Filed2]),([Filed2]-[Filed1])))
Click to expand...
Click to expand...
 
S

Silvio

I am glad to see that I am not the only one :)

Damon Heron said:
I just had one of those DUH moments - Tom Lake gave me a wake-up call.

Damon

Damon Heron said:
=IIf(([filed1]<0 And [filed2]<0) Or ([filed1]>0 And
[filed2]>0),([filed1]-[filed2]),(Abs([filed1])+Abs(([filed2]))))

Thats provided filed1 (field1??) or filed2 are not = 0.

Damon

Silvio said:
Hello everyone, how can I calculate the distance between two points
(numbers)
in a number line using a calculated field? For example: (Filed1 and Filed
are
saved number in any combination of positive and negative numbers)

Filed1 = -10
Field2 = +15
Number distance = 25 (this is the correct result)

Example 2:
Filed1 = -10
Field2 = -5
Distance = 5 (this is the correct result)

Example 3:
Filed1 = -10
Field2 = 5
Distance = 15 (this is the correct result)

This is what I have done but it does not work with combination of
negative
and positive numbers...

=(IIf(([Filed1]>[Filed2]),Abs([Filed1])-Abs([Filed2]),([Filed2]-[Filed1])))
Click to expand...
Click to expand...
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculate the distance between two 2d co-ordinates 2
Calculate the difference between two row locations? 1
Need to calculate the difference between different pairs of values! 1
Difference between two numbers 2
Macro to add numbers in a text string 5
Will this formula work in Access (distance between Lat/Long points 1
How do you calculate a negative percentage 2
need to search a table such as distance table in road maps. 3

Top