Member Avatar for TNvol66

I'm having a issue of a variable I'm setting in my PL/SQL Program. I'm subtracting two Number Data types and dividing those by the lower number to get a percent change. Now, for instance, that number is a 2.5. How can I assign that to it's correct value in the variable of .25?

Thanks for you help!

Example:

PRICEDIFF := (PRICE1 - PRICE2) / PRICE2
Edited by TNvol66 because: n/a
  • 2 Contributors
  • 1 Reply
  • 98 Views
  • 11 Hours Discussion Span
  • Latest Post Latest Post by hfx642
Member Avatar for hfx642

Which value is 2.5?... Price1?... Price2?... PriceDiff?
Of the variables that are NOT 2.5, what are the other values?
How do you know that 0.25 is the correct value?
0.25 is the correct value of which variable?
Your question does not make any sence without more information.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.