Subject | Re: [firebird-support] How do I determine a percentage of a dollar amount? |
---|---|
Author | Marcin Bury |
Post date | 2011-07-11T16:01:22Z |
Hello Mike
As far as I remember 60% is 0.6 so when you supply percentage as
parameter you should perform following calculation:
result = (amount_in_dollars) * (a_percentage) / 100
This should do the trick ;-)
Marcin
W dniu 11.07.2011 17:56, SoftTech pisze:
As far as I remember 60% is 0.6 so when you supply percentage as
parameter you should perform following calculation:
result = (amount_in_dollars) * (a_percentage) / 100
This should do the trick ;-)
Marcin
W dniu 11.07.2011 17:56, SoftTech pisze:
> Greetings All,
>
> Firebird 1.53
>
> Inside a stored procedure I need to determine the percentage of a dollar
> amount.
>
> Is there a function or code that will return say 60% of $150.00?
>
> Thanks to anyone that replies,
>
> Mike
>
>
>
> ------------------------------------
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> Yahoo! Groups Links
>
>
>
>