Keith, this is the all the code and still no luck with the spaces.
The last line is the code that is giving the error message
Bob Scrimsher
ymd(LaborDtl.PayrollDate) format "x(10)" column-label "Dimension
Payroll Date"
fiscal(LaborDtl.PayrollDate) format "x(7)" column-label "Dimension
Fiscal Payroll Date"
LaborDtl.WCCode column-label "Dimension Workcenter"
WrkCenter.Plant column-label "Dimension Plant"
LaborDtl.LaborType column-label "Dimension Labor Type"
LaborDtl.ExpenseCode column-label "Dimension Expense Code"
WrkCenter.JCDept column-label "Dimension Department"
LaborHed.Shift column-label "Dimension Shift"
EmpBasic.SupervisorId column-label "Dimension Supervisor"
LaborDtl.EarnedHrs format "->>,>>9.99" column-label "Fact Earned
Hours"
LaborDtl.BurdenHrs format "->>,>>9.99" column-label "Fact Total Burden
Hours"
LaborDtl.LaborHrs format "->>,>>9.99" column-label "Fact Total Labor
Hours"
WrkCenter.ProdBurRate format "$->>>,>>>,>>>,>>9.99" column-label "Fact
Burden Rate"
(if not LaborDtl.Rework and not LaborDtl.AddedOper then
LaborDtl.BurdenHrs else 0) format "->>,>>9.99" column-label "Fact
Burden Hours"
(if LaborDtl.Rework then LaborDtl.BurdenHrs else 0) format
"->>,>>9.99" column-label "Fact Rework Hours"
(if LaborDtl.AddedOper then LaborDtl.BurdenHrs else 0) format
"->>,>>9.99" column-label "Fact Added Operation Hours"
(if LaborDtl.LaborType <> 'I':U then LaborDtl.LaborHrs else 0) format
"->>,>>9.99" column-label "Fact Direct Hours"
(if LaborDtl.LaborType = 'I':U then LaborDtl.LaborHrs else 0) format
"->>,>>9.99" column-label "Fact Indirect Hours"
0 format "->>9.99%" column-label "Calculation Efficiency % (Earned
Hours/Burden Hours)"
0 format "->>9.99%" column-label "Calculation Performance % (Earned
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Coverage % (Burden
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Rework % (Rework
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Added Operation % (Added
Operation Hours/Total Burden Hours)"
0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
(Burden Rate * Total Burden Hours)"
The last line is the code that is giving the error message
Bob Scrimsher
ymd(LaborDtl.PayrollDate) format "x(10)" column-label "Dimension
Payroll Date"
fiscal(LaborDtl.PayrollDate) format "x(7)" column-label "Dimension
Fiscal Payroll Date"
LaborDtl.WCCode column-label "Dimension Workcenter"
WrkCenter.Plant column-label "Dimension Plant"
LaborDtl.LaborType column-label "Dimension Labor Type"
LaborDtl.ExpenseCode column-label "Dimension Expense Code"
WrkCenter.JCDept column-label "Dimension Department"
LaborHed.Shift column-label "Dimension Shift"
EmpBasic.SupervisorId column-label "Dimension Supervisor"
LaborDtl.EarnedHrs format "->>,>>9.99" column-label "Fact Earned
Hours"
LaborDtl.BurdenHrs format "->>,>>9.99" column-label "Fact Total Burden
Hours"
LaborDtl.LaborHrs format "->>,>>9.99" column-label "Fact Total Labor
Hours"
WrkCenter.ProdBurRate format "$->>>,>>>,>>>,>>9.99" column-label "Fact
Burden Rate"
(if not LaborDtl.Rework and not LaborDtl.AddedOper then
LaborDtl.BurdenHrs else 0) format "->>,>>9.99" column-label "Fact
Burden Hours"
(if LaborDtl.Rework then LaborDtl.BurdenHrs else 0) format
"->>,>>9.99" column-label "Fact Rework Hours"
(if LaborDtl.AddedOper then LaborDtl.BurdenHrs else 0) format
"->>,>>9.99" column-label "Fact Added Operation Hours"
(if LaborDtl.LaborType <> 'I':U then LaborDtl.LaborHrs else 0) format
"->>,>>9.99" column-label "Fact Direct Hours"
(if LaborDtl.LaborType = 'I':U then LaborDtl.LaborHrs else 0) format
"->>,>>9.99" column-label "Fact Indirect Hours"
0 format "->>9.99%" column-label "Calculation Efficiency % (Earned
Hours/Burden Hours)"
0 format "->>9.99%" column-label "Calculation Performance % (Earned
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Coverage % (Burden
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Rework % (Rework
Hours/Total Burden Hours)"
0 format "->>9.99%" column-label "Calculation Added Operation % (Added
Operation Hours/Total Burden Hours)"
0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
(Burden Rate * Total Burden Hours)"
--- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> You need a space before and after the math symbol
>
> Keith E. Taylor
> Vice President
> LBSi
> Business Systems Consultants (Progress based ERP packages)
> 216/476-1416 ext 26
> keith@l...
>
> -----Original Message-----
> From: scrimsher_robert_b@c...
[mailto:scrimsher_robert_b@c...]
> Sent: Tuesday, January 16, 2001 11:16 AM
> To: vantage@egroups.com
> Subject: [Vantage] Re: Business Entelligence Queries
>
> 0 format "$->>>,>>>,>>>,>>9.99" column-label "Calculation Revue $
> (Burden Rate*Total Burden Hours)"
>
>
> --- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> > What is your exact formula calculation?
> >
> > Keith E. Taylor
> > Vice President
> > LBSi
> > Business Systems Consultants (Progress based ERP packages)
> > 216/476-1416 ext 26
> > keith@l...
> >
> > -----Original Message-----
> > From: scrimsher_robert_b@c...
> [mailto:scrimsher_robert_b@c...]
> > Sent: Tuesday, January 16, 2001 8:54 AM
> > To: vantage@egroups.com
> > Subject: [Vantage] Re: Business Entelligence Queries
> >
> > Keith, thanks for the reply, when I try to refresh the data set I
> get
> > an error the format of the calulated field is invalid. using the
> > asterisk.
> >
> > Bob Scrimsher
> >
> >
> >
> > --- In vantage@egroups.com, "Keith Taylor" <keith@l...> wrote:
> > > You hit it on the head...multiple is the * symbol (asterisk). If
> > you
> > are
> > > referring to Report builder help (Progress) it is on line
> > www.progress.com
> > > or available by CD that I think Epicor provides with the
software.
> > >
> > > Keith E. Taylor
> > > Vice President
> > > LBSi
> > > Business Systems Consultants (Progress based ERP packages)
> > > 216/476-1416 ext 26
> > > keith@l...
> > >
> > > -----Original Message-----
> > > From: scrimsher_robert_b@c...
> > [mailto:scrimsher_robert_b@c...]
> > > Sent: Tuesday, January 16, 2001 8:06 AM
> > > To: vantage@egroups.com
> > > Subject: [Vantage] Business Entelligence Queries
> > >
> > > Hi all, We have just started working with the enterprise
business
> > > system and the help available on the canned help screens is not
> much
> > > help. I am seeking information on how to write the queries. Is
> the
> > > any external information that's available? I have written
several
> > > queries and can not seem to mulitply using * x or any other
letter
> > or
> > > number or symbol. has anyone had this problem.
> > >
> > > Bob Scrimsher
> > > "CAT"
> > >
> > >
> > > To unsubscribe from this group, send an email to:
> > > vantage-unsubscribe@egroups.com
> >
> >
> > To unsubscribe from this group, send an email to:
> > vantage-unsubscribe@egroups.com
>
>
> To unsubscribe from this group, send an email to:
> vantage-unsubscribe@egroups.com