Calc help please - comp.databases.filemaker

Our club re sells items. I have two fields "theirprice" and "ourprice" Could someone please help with a calc that would display the percentage of markup "ourprice" is in a new field? Thanks in advance, Michael --

Try this: your new calc field is called percent_increase. The actual math is: 100*((ourprice-theirprice)/theirprice)) Explanation: 1. Ourprice-theirprice = pricediff. 2. pricediff/theirprice = ratio of ourprice:theirprice 3. 100* ratio = % increase. That should do it. "The Wolf" <elvispmpsd@earthlink.net> wrote in message news:BBCECD9D.43A36%elvispmpsd@earthlink.net... > Our club re sells items. > > I have two fields "theirprice" and "ourprice" > > Could someone please help with a calc that would display the percentage of > markup "ourprice" is in a new field? > > Thanks in advance, > Michael > -- >

On 11/5/03 4:50 PM, in article LVgqb.154991$7B1.154494@news04.bloor.is.net.cable.rogers.com, "Mimi" <essayhelp@rogers.com> opined: > Try this: > > your new calc field is called percent_increase. The actual math is: > > 100*((ourprice-theirprice)/theirprice)) > > Explanation: > > 1. Ourprice-theirprice = pricediff. > 2. pricediff/theirprice = ratio of ourprice:theirprice > 3. 100* ratio = % increase. > > That should do it. > > "The Wolf" <elvispmpsd@earthlink.net> wrote in message > news:BBCECD9D.43A36%elvispmpsd@earthlink.net... >> Our club re sells items. >> >> I have two fields "theirprice" and "ourprice" >> >> Could someone please help with a calc that would display the percentage of >> markup "ourprice" is in a new field? >> >> Thanks in advance, >> Michael >> -- >> > > Doesn't seem to work It returns something like %1024.999999333888888 --

In article <BBCEE29A.43A44%elvispmpsd@earthlink.net>, The Wolf <elvispmpsd@earthlink.net> wrote: > On 11/5/03 4:50 PM, in article > LVgqb.154991$7B1.154494@news04.bloor.is.net.cable.rogers.com, "Mimi" > <essayhelp@rogers.com> opined: > > > > "The Wolf" <elvispmpsd@earthlink.net> wrote in message > > news:BBCECD9D.43A36%elvispmpsd@earthlink.net... > >> Our club re sells items. > >> > >> I have two fields "theirprice" and "ourprice" > >> > >> Could someone please help with a calc that would display the percentage of > >> markup "ourprice" is in a new field? > > > > Try this: > > > > your new calc field is called percent_increase. The actual math is: > > > > 100*((ourprice-theirprice)/theirprice)) > > > > Explanation: > > > > 1. Ourprice-theirprice = pricediff. > > 2. pricediff/theirprice = ratio of ourprice:theirprice > > 3. 100* ratio = % increase. > > > > That should do it. > > Doesn't seem to work It returns something like %1024.999999333888888 If you're formatting the field on the layout as a % number, then leave out the "100 *" from above calculation - the formatting does that for you. That would give you a value of "10.24999999333888888" from your example, which would be a little more realistic ... unless you're working for Microsoft. ;o) Helpful Harry "Just trying to help whenever I can." :o)

Hey Michael, Turn off the formatting as % in the field, then set the precision to 0 decimal places. "The Wolf" <elvispmpsd@earthlink.net> wrote in message news:BBCEE29A.43A44%elvispmpsd@earthlink.net... > On 11/5/03 4:50 PM, in article > LVgqb.154991$7B1.154494@news04.bloor.is.net.cable.rogers.com, "Mimi" > <essayhelp@rogers.com> opined: > > > Try this: > > > > your new calc field is called percent_increase. The actual math is: > > > > 100*((ourprice-theirprice)/theirprice)) > > > > Explanation: > > > > 1. Ourprice-theirprice = pricediff. > > 2. pricediff/theirprice = ratio of ourprice:theirprice > > 3. 100* ratio = % increase. > > > > That should do it. > > > > "The Wolf" <elvispmpsd@earthlink.net> wrote in message > > news:BBCECD9D.43A36%elvispmpsd@earthlink.net... > >> Our club re sells items. > >> > >> I have two fields "theirprice" and "ourprice" > >> > >> Could someone please help with a calc that would display the percentage of > >> markup "ourprice" is in a new field? > >> > >> Thanks in advance, > >> Michael > >> -- > >> > > > > > Doesn't seem to work It returns something like %1024.999999333888888 > -- >

On 11/5/03 7:34 PM, in article Bjjqb.22956$YN6.18732@news02.bloor.is.net.cable.rogers.com, "Mimi" <essayhelp@rogers.com> opined: > Hey Michael, > > Turn off the formatting as % in the field, then set the precision to 0 > decimal places. > Thank you! > > "The Wolf" <elvispmpsd@earthlink.net> wrote in message > news:BBCEE29A.43A44%elvispmpsd@earthlink.net... >> On 11/5/03 4:50 PM, in article >> LVgqb.154991$7B1.154494@news04.bloor.is.net.cable.rogers.com, "Mimi" >> <essayhelp@rogers.com> opined: >> >>> Try this: >>> >>> your new calc field is called percent_increase. The actual math is: >>> >>> 100*((ourprice-theirprice)/theirprice)) >>> >>> Explanation: >>> >>> 1. Ourprice-theirprice = pricediff. >>> 2. pricediff/theirprice = ratio of ourprice:theirprice >>> 3. 100* ratio = % increase. >>> >>> That should do it. >>> >>> "The Wolf" <elvispmpsd@earthlink.net> wrote in message >>> news:BBCECD9D.43A36%elvispmpsd@earthlink.net... >>>> Our club re sells items. >>>> >>>> I have two fields "theirprice" and "ourprice" >>>> >>>> Could someone please help with a calc that would display the percentage > of >>>> markup "ourprice" is in a new field? >>>> >>>> Thanks in advance, >>>> Michael >>>> -- >>>> >>> >>> >> Doesn't seem to work It returns something like %1024.999999333888888 >> -- >> > > -- ========================================================================== "When a broad table is to be made, and the edges of planks do not fit, the artist takes a little from both, and makes a good joint. In like manner here, both sides must part with some of their demands," Benjamin Franklin (1706-1790) ==========================================================================

On 11/5/03 7:29 PM, in article 061120031629053015%helpful_harry@nom.de.plume.com, "Helpful Harry" <helpful_harry@nom.de.plume.com> opined: > > > If you're formatting the field on the layout as a % number, then leave > out the "100 *" from above calculation - the formatting does that for > you. > > That would give you a value of "10.24999999333888888" from your > example, which would be a little more realistic ... unless you're > working for Microsoft. ;o) > > > > Helpful Harry > "Just trying to help whenever I can." :o) If I don't have a price entered for OurPrice why does the Calculation return 100%- if I have don't evaluate if fields are empty? I would think the calculation field should stay blank or return 0 in that case. Thanks, Michael --

In article <BBCF1F1E.43A61%elvispmpsd@earthlink.net>, The Wolf <elvispmpsd@earthlink.net> wrote: > On 11/5/03 7:29 PM, in article > 061120031629053015%helpful_harry@nom.de.plume.com, "Helpful Harry" > <helpful_harry@nom.de.plume.com> opined: > > > > If you're formatting the field on the layout as a % number, then leave > > out the "100 *" from above calculation - the formatting does that for > > you. > > > > That would give you a value of "10.24999999333888888" from your > > example, which would be a little more realistic ... unless you're > > working for Microsoft. ;o) > > If I don't have a price entered for OurPrice why does the Calculation return > 100%- if I have don't evaluate if fields are empty? I would think the > calculation field should stay blank or return 0 in that case. Errr ... no. The calculation is 100*((ourprice-theirprice)/theirprice)) If you leave OurPrice empty (ie. 0), then you get 100 * ((0 - TheirPrice)/TheirPrice) = 100 * (-TheirPrice / TheirPrice) = 100 * -1 = -100 By leaving the OurPrice field empty you basically saying you're buying the product at TheirPrice and giving it away free, therefore you make -100% on the deal. :o) Helpful Harry "Just trying to help whenever I can." :o)

On 11/5/03 10:28 PM, in article 061120031928192443%helpful_harry@nom.de.plume.com, "Helpful Harry" <helpful_harry@nom.de.plume.com> opined: > In article <BBCF1F1E.43A61%elvispmpsd@earthlink.net>, The Wolf > <elvispmpsd@earthlink.net> wrote: > >> On 11/5/03 7:29 PM, in article >> 061120031629053015%helpful_harry@nom.de.plume.com, "Helpful Harry" >> <helpful_harry@nom.de.plume.com> opined: >>> >>> If you're formatting the field on the layout as a % number, then leave >>> out the "100 *" from above calculation - the formatting does that for >>> you. >>> >>> That would give you a value of "10.24999999333888888" from your >>> example, which would be a little more realistic ... unless you're >>> working for Microsoft. ;o) >> >> If I don't have a price entered for OurPrice why does the Calculation return >> 100%- if I have don't evaluate if fields are empty? I would think the >> calculation field should stay blank or return 0 in that case. > > Errr ... no. > > The calculation is 100*((ourprice-theirprice)/theirprice)) > > If you leave OurPrice empty (ie. 0), then you get > > 100 * ((0 - TheirPrice)/TheirPrice) = 100 * (-TheirPrice / TheirPrice) > = 100 * -1 > = -100 > > By leaving the OurPrice field empty you basically saying you're buying > the product at TheirPrice and giving it away free, therefore you make > -100% on the deal. :o) > > Helpful Harry > "Just trying to help whenever I can." :o) Gotcha --

Similiar Articles:

FileMaker Hosts preference file - comp.databases.filemaker ...
... from PC to hp 48GX - comp.sys.hp48... the same on both parts (PC & calc) - have a preference ... stack level 1) and files on its computer host, use ... Calc help please ...

SAS Beginner Pls Help - comp.soft-sys.sas
SAS: decimal place issues - comp.soft-sys.sas Calc help please - comp.databases.filemaker... as % in the field, then set the precision to 0 decimal places. ...

How compare two dates or convert date to number - comp.lang.perl ...
Help please... Date::Calc is your friend. Of course, had you used an ISO-8601 compliant format then a simple alphanumerical comparision using 'le' would have been ...

Date Range Calculation - comp.databases.filemaker
Looking for some help please FileMaker6 on Mac. I have a database of invoices from many years. What I would like to create is a layout in which I ...

file,lib tranfers from PC to hp 48GX - comp.sys.hp48
... help please fbarbaise@yahoo.fr wrote: > Hi, > > To connect your HP-48GX to the PC, be sure that: > - you have selected the correct COM port and plugged the calc on it ...

hp 48 programs and hp 49g+ programs - comp.sys.hp48
I send it to calc by xserver and when i go to var and i execute it, te program is only a text in lcd and i cannot execute it. If you can help me please send me an e-mail ...

FoxPro 2.6 DOS Run Error - comp.databases.xbase.fox
I get !/Run Command Failed. Help? Please note: In this case, google is NOT my friend. ... if within the application, called the calculator: run calc.exe ran and was not ...

Relationship - finding one field based on value in another - comp ...
Please help this long term Access and SQL Server programmer learning FileMaker. ... (stored calc and indexed) Then define a global calc (e.g. globalcalc1) in the ...

EE*Pro 49G/50G - comp.sys.hp48
... program I hope you can understand me that I want to help to ... save transfer function in it? > > Thanks again, > Damir Please download the EE*Pro User's Guide for TI-Calc ...

Rounded 1/4 hours calculations as totals - comp.databases ...
Could you break down your calc with which field ... Thanks for your help (or anyone else that can assist). ... If you're on FM7, please describe what happens when you ...

Pre Calc help, please? - Yahoo! Answers
Best Answer: 1) it just direct calculation radius =7926 * 1.6093/2 =6377.6559 =6378 km check the graph http://img195.imageshack.us/img195/8679/… 2) Let ...

Calculus Help PLease? - Yahoo! Answers
Best Answer: Well, you know that the areas are different. Just find the roots of Ix-2I. So whenever x-2 goes negative, just turn it positive.

7/15/2012 1:13:20 PM