Calculating total payroll hours for a period using BAQ

system · October 31, 2013, 7:10am

What version are you? I think if you do Copy To Excel the summary comes along for the ride.

From: "sanfranc415@..." <sanfranc415@...>
To: vantage@yahoogroups.com
Sent: Wednesday, October 30, 2013 6:32 PM
Subject: RE: Re: [Vantage] Calculating total payroll hours for a period using BAQ

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693 --

#ygrps-yiv-2084602764yiv0864051693 .ygrps-yiv-2084602764yiv0864051693ygrp-photo-title{
clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;}
#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693ygrp-photo{
background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693photo-title
a,
#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693photo-title a:active,
#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693photo-title a:hover,
#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693photo-title a:visited {
text-decoration:none;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693attach-table div.ygrps-yiv-2084602764yiv0864051693attach-row {
clear:both;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693attach-table div.ygrps-yiv-2084602764yiv0864051693attach-row div {
float:left;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 p {
clear:both;padding:15px 0 3px 0;overflow:hidden;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693ygrp-file {
width:30px;}
#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693attach-table div.ygrps-yiv-2084602764yiv0864051693attach-row div div a {
text-decoration:none;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693attach-table div.ygrps-yiv-2084602764yiv0864051693attach-row div div span {
font-weight:normal;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 div.ygrps-yiv-2084602764yiv0864051693ygrp-file-title {
font-weight:bold;}
#ygrps-yiv-2084602764
#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693 –
#ygrps-yiv-2084602764yiv0864051693ygrp-mkp {
border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrp-mkp hr {
border:1px solid #d8d8d8;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrp-mkp #ygrps-yiv-2084602764yiv0864051693hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrp-mkp #ygrps-yiv-2084602764yiv0864051693ads {
margin-bottom:10px;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrp-mkp .ygrps-yiv-2084602764yiv0864051693ad {
padding:0 0;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrp-mkp .ygrps-yiv-2084602764yiv0864051693ad p {
margin:0;}

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrp-mkp .ygrps-yiv-2084602764yiv0864051693ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-2084602764

Thanks, that works some what. Still not able to extract data into an excel spreadsheet since the summarizes expand when copied and pasted.

---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Can you just use Show Summaries on the grid?

From: "sanfranc415@..." <sanfranc415@...>

To: vantage@yahoogroups.com
Sent: Wednesday, October 30, 2013 4:43 PM
Subject: [Vantage] Calculating total payroll hours for a period using BAQ

#ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693 -- #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 .ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-photo-title{ clear:both;font-size:smaller;height:15px;overflow:hidden;text-align:center;width:75px;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-photo{ background-position:center;background-repeat:no-repeat;background-color:white;border:1px solid black;height:62px;width:62px;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159photo-title a, #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159photo-title a:active, #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159photo-title a:hover, #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159photo-title a:visited { text-decoration:none;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-table div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-row { clear:both;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-table div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-row div { float:left;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 p { clear:both;padding:15px 0 3px 0;overflow:hidden;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-file { width:30px;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-table div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-row div div a { text-decoration:none;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-table div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159attach-row div div span { font-weight:normal;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 div.ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-file-title { font-weight:bold;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693 -- #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-mkp { border:1px solid #d8d8d8;font-family:Arial;margin:10px 0;padding:0 10px;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-mkp hr { border:1px solid #d8d8d8;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-mkp #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159hd { color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-mkp #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ads { margin-bottom:10px;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-mkp .ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ad { padding:0 0;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-mkp .ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ad p { margin:0;} #ygrps-yiv-2084602764 #ygrps-yiv-2084602764yiv0864051693 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159 #ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ygrp-mkp .ygrps-yiv-2084602764yiv0864051693ygrps-yiv-84331129yiv0058814159ad a { color:#0000ff;text-decoration:none;} #ygrps-yiv-2084602764

I've created a BAQ to display employee and payhours for a period, but how to calculate the total payhours for that period? Is this done by creating a field CALC and generating an expression?

system · October 30, 2013, 4:43pm

I've created a BAQ to display employee and payhours for a period, but how to calculate the total payhours for that period? Is this done by creating a field CALC and generating an expression?

system · October 30, 2013, 5:13pm

Can you just use Show Summaries on the grid?

From: "sanfranc415@..." <sanfranc415@...>
To: vantage@yahoogroups.com
Sent: Wednesday, October 30, 2013 4:43 PM
Subject: [Vantage] Calculating total payroll hours for a period using BAQ

I've created a BAQ to display employee and payhours for a period, but how to calculate the total payhours for that period? Is this done by creating a field CALC and generating an expression?

system · October 30, 2013, 6:32pm

Thanks, that works some what. Still not able to extract data into an excel spreadsheet since the summarizes expand when copied and pasted.

---In vantage@yahoogroups.com, <vantage@yahoogroups.com> wrote:

Can you just use Show Summaries on the grid?

From: "sanfranc415@..." <sanfranc415@...>
To: vantage@yahoogroups.com
Sent: Wednesday, October 30, 2013 4:43 PM
Subject: [Vantage] Calculating total payroll hours for a period using BAQ

I've created a BAQ to display employee and payhours for a period, but how to calculate the total payhours for that period? Is this done by creating a field CALC and generating an expression?