COMPGROUPS.NET | Search | Post Question | Groups | Stream | About | Register

• Follow

```Our club re sells items.

I have two fields "theirprice" and "ourprice"

markup "ourprice" is in a new field?

Michael
--

```
 0

```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
> Our club re sells items.
>
> I have two fields "theirprice" and "ourprice"
>
> markup "ourprice" is in a new field?
>
> Michael
> --
>

```
 0

```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
>> Our club re sells items.
>>
>> I have two fields "theirprice" and "ourprice"
>>
>> markup "ourprice" is in a new field?
>>
>> Michael
>> --
>>
>
>
Doesn't seem to work It returns something like %1024.999999333888888
--

```
 0

```In article <BBCEE29A.43A44%elvispmpsd@earthlink.net>, The Wolf

> 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
> >> Our club re sells items.
> >>
> >> I have two fields "theirprice" and "ourprice"
> >>
> >> 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)

"Just trying to help whenever I can."      :o)
```
 0

```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
> 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
> >> Our club re sells items.
> >>
> >> I have two fields "theirprice" and "ourprice"
> >>
of
> >> markup "ourprice" is in a new field?
> >>
> >> Michael
> >> --
> >>
> >
> >
> Doesn't seem to work It returns something like %1024.999999333888888
> --
>

```
 0

```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
>> 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
>>>> Our club re sells items.
>>>>
>>>> I have two fields "theirprice" and "ourprice"
>>>>
> of
>>>> markup "ourprice" is in a new field?
>>>>
>>>> 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)
==========================================================================

```
 0

```On 11/5/03 7:29 PM, in article

>
>
> 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)
>
>
>
> "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
--

```
 0

```In article <BBCF1F1E.43A61%elvispmpsd@earthlink.net>, The Wolf

> On 11/5/03 7:29 PM, in article
> >
> > 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)

"Just trying to help whenever I can."      :o)
```
 0

```On 11/5/03 10:28 PM, in article

> In article <BBCF1F1E.43A61%elvispmpsd@earthlink.net>, The Wolf
>
>> On 11/5/03 7:29 PM, in article
>>>
>>> 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)
>
> "Just trying to help whenever I can."      :o)
Gotcha

--

```
 0

8 Replies
178 Views

Similiar Articles:

7/15/2012 1:13:20 PM