Numerical comparisson function??

[Guest]

Morning to All,

is there a comparisson function that will take two numerical values and give
a percentage difference between them (negative and positive percentages)

Regards

Jai

 

[Guest]

Hi Jai,

There is no paerticular function that I'm aware of, it's down to you to
calculate the percentage;
((x/y)*100)
but obviously you are wanting more than that, as it will return percentages
above or below 100 percent rather than negative values, if you could post
sample values and the expected results, we can have a better idea of what
rules need to be followed, eg 1st number / second number = percentage or
smallest number as a percentage of largest etc etc

TonyT..

 

[Guest]

Try this --
(([Last]-[First])/[First]*100)

 

[Guest]

Cheers for the input...

Don't think it worked completley
I actually had to use the following syntax :-

(([First value]-[Second Value])/[First Vale])*100

Example output

First Value Second Value Percentage
0 0 #error (need to use function to
bypass error)
100 100 0
100 50 50
50 100 -100 (if the above if 50 %
shouldnt this be -50%)
100 0 100
0 100 #error (shouldn't this be -100 %)
20 19 5
800 2 99.75
19 20 -5.263157


Jai Friday

Try this --
(([Last]-[First])/[First]*100)

Morning to All,

is there a comparisson function that will take two numerical values and give
a percentage difference between them (negative and positive percentages)

Regards

Jai