BAQ Calculated field - V8

Yahoo Archive
1
I think the problem is that you can’t combine a summarized field with a non-summarized field in the BAQ.

You can get the separate pieces, but not both combined.

Neither formula will work. The first because you are trying to combine the summarized with non-summarized and the second because you are trying to use detail level information in a summary field.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of Steven Gotschall
Sent: Monday, February 15, 2010 11:57 AM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] BAQ Calculated field - V8





Try this:

TOTAL((IF LaborHed.PayHours > 0 THEN (LaborDtl. BurdenHrs / LaborHed.PayHours) ELSE (0)))

________________________________
From: CTCharlie <CSmith@... <mailto:CSmith%40vistaconsultant.com> >
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Sent: Mon, February 15, 2010 11:46:28 AM
Subject: [Vantage] BAQ Calculated field - V8


I am having problems with a V8 calculated BAQ field.
The LaborHed is getting detailed and the LaborDtl is getting summarized.
When I put the formula together I keep getting a syntax error regardless how I do it. Anyone have any answers?

BurdenEff
IF LaborHed.PayHours > 0 THEN TOTAL(LaborDtl. BurdenHrs) / LaborHed.PayHours ELSE 0
Format: ->>9.99999
Decimal

[Non-text portions of this message have been removed]





[Non-text portions of this message have been removed]
2
I am having problems with a V8 calculated BAQ field.
The LaborHed is getting detailed and the LaborDtl is getting summarized.
When I put the formula together I keep getting a syntax error regardless how I do it. Anyone have any answers?

BurdenEff
IF LaborHed.PayHours > 0 THEN TOTAL(LaborDtl.BurdenHrs) / LaborHed.PayHours ELSE 0
Format: ->>9.99999
Decimal
3
Try this:

TOTAL((IF LaborHed.PayHours > 0 THEN (LaborDtl. BurdenHrs / LaborHed.PayHours) ELSE (0)))




________________________________
From: CTCharlie <CSmith@...>
To: vantage@yahoogroups.com
Sent: Mon, February 15, 2010 11:46:28 AM
Subject: [Vantage] BAQ Calculated field - V8

Â
I am having problems with a V8 calculated BAQ field.
The LaborHed is getting detailed and the LaborDtl is getting summarized.
When I put the formula together I keep getting a syntax error regardless how I do it. Anyone have any answers?

BurdenEff
IF LaborHed.PayHours > 0 THEN TOTAL(LaborDtl. BurdenHrs) / LaborHed.PayHours ELSE 0
Format: ->>9.99999
Decimal







[Non-text portions of this message have been removed]