Creating Calculations Within a Field

Hello,

I have an Activity field with various activities and I would like to
calculate the time values between these activities.

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh

Hi

assume your example is in cells A1:B4
the formula you're looking for is B4-B2

Cheers
JulieD


"MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
> Hello,
>
> I have an Activity field with various activities and I would like to
> calculate the time values between these activities.
>
> For example:
> Activity (Field) Time (Avg)
> Stand 12:00
> Run 13:00
> Stop 13:30
>
> I would like to add a calculation within Activity that is Stop - Stand. I
> greatly appreciate any help. Thanks!
>
> Minh
>
>
>
>
>

I should have mentioned that I am working with a pivot table. Is it possible
to create a formula within a field?

For example:
Activity (Field) Time (Avg)
Stand 12:00
Run 13:00
Stop 13:30

I would like to add a calculation within Activity that is Stop - Stand. I
greatly appreciate any help. Thanks!

Minh


"JulieD" wrote:

> Hi
>
> assume your example is in cells A1:B4
> the formula you're looking for is B4-B2
>
> Cheers
> JulieD
>
>
> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
> > Hello,
> >
> > I have an Activity field with various activities and I would like to
> > calculate the time values between these activities.
> >
> > For example:
> > Activity (Field) Time (Avg)
> > Stand 12:00
> > Run 13:00
> > Stop 13:30
> >
> > I would like to add a calculation within Activity that is Stop - Stand. I
> > greatly appreciate any help. Thanks!
> >
> > Minh
> >
> >
> >
> >
> >
>
>
>

Hi

you can add calculated fields to pivot tables, on the pivot table toolbar,
click on the pivot table icon and choose formula ... see how you go.

Cheers
JulieD

"MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
news:CCC37CC1-CF1F-4590-A886-B24B219F50BC@microsoft.com...
>I should have mentioned that I am working with a pivot table. Is it
>possible
> to create a formula within a field?
>
> For example:
> Activity (Field) Time (Avg)
> Stand 12:00
> Run 13:00
> Stop 13:30
>
> I would like to add a calculation within Activity that is Stop - Stand. I
> greatly appreciate any help. Thanks!
>
> Minh
>
>
> "JulieD" wrote:
>
>> Hi
>>
>> assume your example is in cells A1:B4
>> the formula you're looking for is B4-B2
>>
>> Cheers
>> JulieD
>>
>>
>> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
>> news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
>> > Hello,
>> >
>> > I have an Activity field with various activities and I would like to
>> > calculate the time values between these activities.
>> >
>> > For example:
>> > Activity (Field) Time (Avg)
>> > Stand 12:00
>> > Run 13:00
>> > Stop 13:30
>> >
>> > I would like to add a calculation within Activity that is Stop - Stand.
>> > I
>> > greatly appreciate any help. Thanks!
>> >
>> > Minh
>> >
>> >
>> >
>> >
>> >
>>
>>
>>

I could see how I would calculate between various fields, but I could not set
up a calculation within the field itself. Did I overlook something?

I am also trying to group the values, but it does not allow for subtraction
(only summing).

"JulieD" wrote:

> Hi
>
> you can add calculated fields to pivot tables, on the pivot table toolbar,
> click on the pivot table icon and choose formula ... see how you go.
>
> Cheers
> JulieD
>
> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> news:CCC37CC1-CF1F-4590-A886-B24B219F50BC@microsoft.com...
> >I should have mentioned that I am working with a pivot table. Is it
> >possible
> > to create a formula within a field?
> >
> > For example:
> > Activity (Field) Time (Avg)
> > Stand 12:00
> > Run 13:00
> > Stop 13:30
> >
> > I would like to add a calculation within Activity that is Stop - Stand. I
> > greatly appreciate any help. Thanks!
> >
> > Minh
> >
> >
> > "JulieD" wrote:
> >
> >> Hi
> >>
> >> assume your example is in cells A1:B4
> >> the formula you're looking for is B4-B2
> >>
> >> Cheers
> >> JulieD
> >>
> >>
> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> >> news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
> >> > Hello,
> >> >
> >> > I have an Activity field with various activities and I would like to
> >> > calculate the time values between these activities.
> >> >
> >> > For example:
> >> > Activity (Field) Time (Avg)
> >> > Stand 12:00
> >> > Run 13:00
> >> > Stop 13:30
> >> >
> >> > I would like to add a calculation within Activity that is Stop - Stand.
> >> > I
> >> > greatly appreciate any help. Thanks!
> >> >
> >> > Minh
> >> >
> >> >
> >> >
> >> >
> >> >
> >>
> >>
> >>
>
>
>

Hi

can you post a 5 line example of the data that the pivot table is based on
....
please don't attach a workbook just type it out the format
.......A........B.............C..............D
1....data...data........data..........data

thanks - as i'ld like to try out a few ideas

Cheers
JulieD

"MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
news:769D421D-1FD0-4C40-8414-19B065A06107@microsoft.com...
>I could see how I would calculate between various fields, but I could not
>set
> up a calculation within the field itself. Did I overlook something?
>
> I am also trying to group the values, but it does not allow for
> subtraction
> (only summing).
>
> "JulieD" wrote:
>
>> Hi
>>
>> you can add calculated fields to pivot tables, on the pivot table
>> toolbar,
>> click on the pivot table icon and choose formula ... see how you go.
>>
>> Cheers
>> JulieD
>>
>> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
>> news:CCC37CC1-CF1F-4590-A886-B24B219F50BC@microsoft.com...
>> >I should have mentioned that I am working with a pivot table. Is it
>> >possible
>> > to create a formula within a field?
>> >
>> > For example:
>> > Activity (Field) Time (Avg)
>> > Stand 12:00
>> > Run 13:00
>> > Stop 13:30
>> >
>> > I would like to add a calculation within Activity that is Stop - Stand.
>> > I
>> > greatly appreciate any help. Thanks!
>> >
>> > Minh
>> >
>> >
>> > "JulieD" wrote:
>> >
>> >> Hi
>> >>
>> >> assume your example is in cells A1:B4
>> >> the formula you're looking for is B4-B2
>> >>
>> >> Cheers
>> >> JulieD
>> >>
>> >>
>> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
>> >> news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
>> >> > Hello,
>> >> >
>> >> > I have an Activity field with various activities and I would like to
>> >> > calculate the time values between these activities.
>> >> >
>> >> > For example:
>> >> > Activity (Field) Time (Avg)
>> >> > Stand 12:00
>> >> > Run 13:00
>> >> > Stop 13:30
>> >> >
>> >> > I would like to add a calculation within Activity that is Stop -
>> >> > Stand.
>> >> > I
>> >> > greatly appreciate any help. Thanks!
>> >> >
>> >> > Minh
>> >> >
>> >> >
>> >> >
>> >> >
>> >> >
>> >>
>> >>
>> >>
>>
>>
>>

Here is an example of the data:
Name Activity Time
Jason Walking 0:30:00
Jason Running 0:15:00
Jason Dumbels 0:18:00
Jason Bench 0:13:00
Mark Walking 0:30:00
Mark Running 0:15:00
Mark Dumbels 0:18:00
Mark Bench 0:13:00

In the pivot table, I would like to add a new activity and it is Walking
minus Running. The pivot table will then be:

Activity Total
Bench 0:26:00
Dumbels 0:36:00
Running 0:30:00
Walking 1:00:00
Walking - Running 0:30:00

Thanks for looking into this!


"JulieD" wrote:

> Hi
>
> can you post a 5 line example of the data that the pivot table is based on
> ....
> please don't attach a workbook just type it out the format
> .......A........B.............C..............D
> 1....data...data........data..........data
>
> thanks - as i'ld like to try out a few ideas
>
> Cheers
> JulieD
>
> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> news:769D421D-1FD0-4C40-8414-19B065A06107@microsoft.com...
> >I could see how I would calculate between various fields, but I could not
> >set
> > up a calculation within the field itself. Did I overlook something?
> >
> > I am also trying to group the values, but it does not allow for
> > subtraction
> > (only summing).
> >
> > "JulieD" wrote:
> >
> >> Hi
> >>
> >> you can add calculated fields to pivot tables, on the pivot table
> >> toolbar,
> >> click on the pivot table icon and choose formula ... see how you go.
> >>
> >> Cheers
> >> JulieD
> >>
> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> >> news:CCC37CC1-CF1F-4590-A886-B24B219F50BC@microsoft.com...
> >> >I should have mentioned that I am working with a pivot table. Is it
> >> >possible
> >> > to create a formula within a field?
> >> >
> >> > For example:
> >> > Activity (Field) Time (Avg)
> >> > Stand 12:00
> >> > Run 13:00
> >> > Stop 13:30
> >> >
> >> > I would like to add a calculation within Activity that is Stop - Stand.
> >> > I
> >> > greatly appreciate any help. Thanks!
> >> >
> >> > Minh
> >> >
> >> >
> >> > "JulieD" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> assume your example is in cells A1:B4
> >> >> the formula you're looking for is B4-B2
> >> >>
> >> >> Cheers
> >> >> JulieD
> >> >>
> >> >>
> >> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> >> >> news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
> >> >> > Hello,
> >> >> >
> >> >> > I have an Activity field with various activities and I would like to
> >> >> > calculate the time values between these activities.
> >> >> >
> >> >> > For example:
> >> >> > Activity (Field) Time (Avg)
> >> >> > Stand 12:00
> >> >> > Run 13:00
> >> >> > Stop 13:30
> >> >> >
> >> >> > I would like to add a calculation within Activity that is Stop -
> >> >> > Stand.
> >> >> > I
> >> >> > greatly appreciate any help. Thanks!
> >> >> >
> >> >> > Minh
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >> >
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

Thanks Julie! This is exactly what I needed!

Minh

"JulieD" wrote:

> Hi
>
> i was able to achieve this:
> 1) click on "bench" in the pivot table
> 2) choose pivot table (icon on the toolbar)
> 3) choose formulas
> 4) choose CALCULATED ITEM
> 5) called it WR
> 6) typed the formula
> = Walking - Running
>
> and clicked on OK
>
> Cheers
> JulieD
> PS i'm using Ver 2003 not sure when this option was made available (never
> done it before)
>
> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> news:63653FC9-A2E6-42AE-A7B9-27945698A4E2@microsoft.com...
> > Here is an example of the data:
> > Name Activity Time
> > Jason Walking 0:30:00
> > Jason Running 0:15:00
> > Jason Dumbels 0:18:00
> > Jason Bench 0:13:00
> > Mark Walking 0:30:00
> > Mark Running 0:15:00
> > Mark Dumbels 0:18:00
> > Mark Bench 0:13:00
> >
> > In the pivot table, I would like to add a new activity and it is Walking
> > minus Running. The pivot table will then be:
> >
> > Activity Total
> > Bench 0:26:00
> > Dumbels 0:36:00
> > Running 0:30:00
> > Walking 1:00:00
> > Walking - Running 0:30:00
> >
> > Thanks for looking into this!
> >
> >
> > "JulieD" wrote:
> >
> >> Hi
> >>
> >> can you post a 5 line example of the data that the pivot table is based
> >> on
> >> ....
> >> please don't attach a workbook just type it out the format
> >> .......A........B.............C..............D
> >> 1....data...data........data..........data
> >>
> >> thanks - as i'ld like to try out a few ideas
> >>
> >> Cheers
> >> JulieD
> >>
> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> >> news:769D421D-1FD0-4C40-8414-19B065A06107@microsoft.com...
> >> >I could see how I would calculate between various fields, but I could
> >> >not
> >> >set
> >> > up a calculation within the field itself. Did I overlook something?
> >> >
> >> > I am also trying to group the values, but it does not allow for
> >> > subtraction
> >> > (only summing).
> >> >
> >> > "JulieD" wrote:
> >> >
> >> >> Hi
> >> >>
> >> >> you can add calculated fields to pivot tables, on the pivot table
> >> >> toolbar,
> >> >> click on the pivot table icon and choose formula ... see how you go.
> >> >>
> >> >> Cheers
> >> >> JulieD
> >> >>
> >> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> >> >> news:CCC37CC1-CF1F-4590-A886-B24B219F50BC@microsoft.com...
> >> >> >I should have mentioned that I am working with a pivot table. Is it
> >> >> >possible
> >> >> > to create a formula within a field?
> >> >> >
> >> >> > For example:
> >> >> > Activity (Field) Time (Avg)
> >> >> > Stand 12:00
> >> >> > Run 13:00
> >> >> > Stop 13:30
> >> >> >
> >> >> > I would like to add a calculation within Activity that is Stop -
> >> >> > Stand.
> >> >> > I
> >> >> > greatly appreciate any help. Thanks!
> >> >> >
> >> >> > Minh
> >> >> >
> >> >> >
> >> >> > "JulieD" wrote:
> >> >> >
> >> >> >> Hi
> >> >> >>
> >> >> >> assume your example is in cells A1:B4
> >> >> >> the formula you're looking for is B4-B2
> >> >> >>
> >> >> >> Cheers
> >> >> >> JulieD
> >> >> >>
> >> >> >>
> >> >> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
> >> >> >> news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
> >> >> >> > Hello,
> >> >> >> >
> >> >> >> > I have an Activity field with various activities and I would like
> >> >> >> > to
> >> >> >> > calculate the time values between these activities.
> >> >> >> >
> >> >> >> > For example:
> >> >> >> > Activity (Field) Time (Avg)
> >> >> >> > Stand 12:00
> >> >> >> > Run 13:00
> >> >> >> > Stop 13:30
> >> >> >> >
> >> >> >> > I would like to add a calculation within Activity that is Stop -
> >> >> >> > Stand.
> >> >> >> > I
> >> >> >> > greatly appreciate any help. Thanks!
> >> >> >> >
> >> >> >> > Minh
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >> >
> >> >> >>
> >> >> >>
> >> >> >>
> >> >>
> >> >>
> >> >>
> >>
> >>
> >>
>
>
>

you're welcome and thanks for the feedback

"MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
news:610DB4DC-424C-4F82-9A30-72F110A6F85D@microsoft.com...
> Thanks Julie! This is exactly what I needed!
>
> Minh
>
> "JulieD" wrote:
>
>> Hi
>>
>> i was able to achieve this:
>> 1) click on "bench" in the pivot table
>> 2) choose pivot table (icon on the toolbar)
>> 3) choose formulas
>> 4) choose CALCULATED ITEM
>> 5) called it WR
>> 6) typed the formula
>> = Walking - Running
>>
>> and clicked on OK
>>
>> Cheers
>> JulieD
>> PS i'm using Ver 2003 not sure when this option was made available (never
>> done it before)
>>
>> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
>> news:63653FC9-A2E6-42AE-A7B9-27945698A4E2@microsoft.com...
>> > Here is an example of the data:
>> > Name Activity Time
>> > Jason Walking 0:30:00
>> > Jason Running 0:15:00
>> > Jason Dumbels 0:18:00
>> > Jason Bench 0:13:00
>> > Mark Walking 0:30:00
>> > Mark Running 0:15:00
>> > Mark Dumbels 0:18:00
>> > Mark Bench 0:13:00
>> >
>> > In the pivot table, I would like to add a new activity and it is
>> > Walking
>> > minus Running. The pivot table will then be:
>> >
>> > Activity Total
>> > Bench 0:26:00
>> > Dumbels 0:36:00
>> > Running 0:30:00
>> > Walking 1:00:00
>> > Walking - Running 0:30:00
>> >
>> > Thanks for looking into this!
>> >
>> >
>> > "JulieD" wrote:
>> >
>> >> Hi
>> >>
>> >> can you post a 5 line example of the data that the pivot table is
>> >> based
>> >> on
>> >> ....
>> >> please don't attach a workbook just type it out the format
>> >> .......A........B.............C..............D
>> >> 1....data...data........data..........data
>> >>
>> >> thanks - as i'ld like to try out a few ideas
>> >>
>> >> Cheers
>> >> JulieD
>> >>
>> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
>> >> news:769D421D-1FD0-4C40-8414-19B065A06107@microsoft.com...
>> >> >I could see how I would calculate between various fields, but I could
>> >> >not
>> >> >set
>> >> > up a calculation within the field itself. Did I overlook something?
>> >> >
>> >> > I am also trying to group the values, but it does not allow for
>> >> > subtraction
>> >> > (only summing).
>> >> >
>> >> > "JulieD" wrote:
>> >> >
>> >> >> Hi
>> >> >>
>> >> >> you can add calculated fields to pivot tables, on the pivot table
>> >> >> toolbar,
>> >> >> click on the pivot table icon and choose formula ... see how you
>> >> >> go.
>> >> >>
>> >> >> Cheers
>> >> >> JulieD
>> >> >>
>> >> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
>> >> >> news:CCC37CC1-CF1F-4590-A886-B24B219F50BC@microsoft.com...
>> >> >> >I should have mentioned that I am working with a pivot table. Is
>> >> >> >it
>> >> >> >possible
>> >> >> > to create a formula within a field?
>> >> >> >
>> >> >> > For example:
>> >> >> > Activity (Field) Time (Avg)
>> >> >> > Stand 12:00
>> >> >> > Run 13:00
>> >> >> > Stop 13:30
>> >> >> >
>> >> >> > I would like to add a calculation within Activity that is Stop -
>> >> >> > Stand.
>> >> >> > I
>> >> >> > greatly appreciate any help. Thanks!
>> >> >> >
>> >> >> > Minh
>> >> >> >
>> >> >> >
>> >> >> > "JulieD" wrote:
>> >> >> >
>> >> >> >> Hi
>> >> >> >>
>> >> >> >> assume your example is in cells A1:B4
>> >> >> >> the formula you're looking for is B4-B2
>> >> >> >>
>> >> >> >> Cheers
>> >> >> >> JulieD
>> >> >> >>
>> >> >> >>
>> >> >> >> "MinhPhan" <MinhPhan@discussions.microsoft.com> wrote in message
>> >> >> >> news:22E8B9D6-0C72-400F-ACEF-D56883F7047C@microsoft.com...
>> >> >> >> > Hello,
>> >> >> >> >
>> >> >> >> > I have an Activity field with various activities and I would
>> >> >> >> > like
>> >> >> >> > to
>> >> >> >> > calculate the time values between these activities.
>> >> >> >> >
>> >> >> >> > For example:
>> >> >> >> > Activity (Field) Time (Avg)
>> >> >> >> > Stand 12:00
>> >> >> >> > Run 13:00
>> >> >> >> > Stop 13:30
>> >> >> >> >
>> >> >> >> > I would like to add a calculation within Activity that is
>> >> >> >> > Stop -
>> >> >> >> > Stand.
>> >> >> >> > I
>> >> >> >> > greatly appreciate any help. Thanks!
>> >> >> >> >
>> >> >> >> > Minh
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >> >
>> >> >> >>
>> >> >> >>
>> >> >> >>
>> >> >>
>> >> >>
>> >> >>
>> >>
>> >>
>> >>
>>
>>
>>