9.05.702A progress - Help with BAQ on summary tables

Yahoo Archive
1
<!-- #ygrps-yiv-388526850 _filtered #ygrps-yiv-388526850 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-388526850 {font-family:Wingdings; panose-1:5 0 0 0 0 0 0 0 0 0;} _filtered #ygrps-yiv-388526850 {font-family:Calibri; panose-1:2 15 5 2 2 2 4 3 2 4;} _filtered #ygrps-yiv-388526850 {font-family:Consolas; panose-1:2 11 6 9 2 2 4 3 2 4;} _filtered #ygrps-yiv-388526850 {font-family:Verdana; panose-1:2 11 6 4 3 5 4 4 2 4;} #ygrps-yiv-388526850 #ygrps-yiv-388526850 p.ygrps-yiv-388526850MsoNormal, #ygrps-yiv-388526850 li.ygrps-yiv-388526850MsoNormal, #ygrps-yiv-388526850 div.ygrps-yiv-388526850MsoNormal {margin:0in; margin-bottom:.0001pt; font-size:12.0pt; font-family:"Times New Roman", "serif";} #ygrps-yiv-388526850 a:link, #ygrps-yiv-388526850 span.ygrps-yiv-388526850MsoHyperlink { color:blue; text-decoration:underline;} #ygrps-yiv-388526850 a:visited, #ygrps-yiv-388526850 span.ygrps-yiv-388526850MsoHyperlinkFollowed { color:purple; text-decoration:underline;} #ygrps-yiv-388526850 p {

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-388526850 code
{
font-family:“Courier New”;}
#ygrps-yiv-388526850 pre
{

margin:0in;
margin-bottom:.0001pt;
font-size:10.0pt;
font-family:“Courier New”;}
#ygrps-yiv-388526850 tt
{
font-family:“Courier New”;}
#ygrps-yiv-388526850 span.ygrps-yiv-388526850HTMLPreformattedChar
{

font-family:Consolas;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850attach, #ygrps-yiv-388526850 li.ygrps-yiv-388526850attach, #ygrps-yiv-388526850 div.ygrps-yiv-388526850attach
{

margin-right:0in;

margin-left:0in;
font-size:9.0pt;
font-family:“Arial”, “sans-serif”;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850bold, #ygrps-yiv-388526850 li.ygrps-yiv-388526850bold, #ygrps-yiv-388526850 div.ygrps-yiv-388526850bold
{

margin-right:0in;

margin-left:0in;
font-size:10.0pt;
font-family:“Arial”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850green, #ygrps-yiv-388526850 li.ygrps-yiv-388526850green, #ygrps-yiv-388526850 div.ygrps-yiv-388526850green
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
color:#628C2A;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850replbq, #ygrps-yiv-388526850 li.ygrps-yiv-388526850replbq, #ygrps-yiv-388526850 div.ygrps-yiv-388526850replbq
{
margin:3.0pt;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850ad, #ygrps-yiv-388526850 li.ygrps-yiv-388526850ad, #ygrps-yiv-388526850 div.ygrps-yiv-388526850ad
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850underline, #ygrps-yiv-388526850 li.ygrps-yiv-388526850underline, #ygrps-yiv-388526850 div.ygrps-yiv-388526850underline
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-388526850 span.ygrps-yiv-388526850yshortcuts
{}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850ad1, #ygrps-yiv-388526850 li.ygrps-yiv-388526850ad1, #ygrps-yiv-388526850 div.ygrps-yiv-388526850ad1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850ad2, #ygrps-yiv-388526850 li.ygrps-yiv-388526850ad2, #ygrps-yiv-388526850 div.ygrps-yiv-388526850ad2
{

margin-right:0in;
margin-bottom:7.5pt;
margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;}
#ygrps-yiv-388526850 p.ygrps-yiv-388526850underline1, #ygrps-yiv-388526850 li.ygrps-yiv-388526850underline1, #ygrps-yiv-388526850 div.ygrps-yiv-388526850underline1
{

margin-right:0in;

margin-left:0in;
font-size:12.0pt;
font-family:“Times New Roman”, “serif”;
text-decoration:underline;}
#ygrps-yiv-388526850 span.ygrps-yiv-388526850yshortcuts1
{
font-family:“Verdana”, “sans-serif”;
font-weight:bold;}
#ygrps-yiv-388526850 span.ygrps-yiv-388526850yshortcuts2
{
font-family:“Verdana”, “sans-serif”;
font-weight:normal;}
#ygrps-yiv-388526850 span.ygrps-yiv-388526850EmailStyle34
{
font-family:“Calibri”, “sans-serif”;
color:#1F497D;}
#ygrps-yiv-388526850 .ygrps-yiv-388526850MsoChpDefault
{
font-size:10.0pt;}
_filtered #ygrps-yiv-388526850 {
margin:1.0in 1.0in 1.0in 1.0in;}
#ygrps-yiv-388526850 div.ygrps-yiv-388526850WordSection1
{}
#ygrps-yiv-388526850
_filtered #ygrps-yiv-388526850 {
}
_filtered #ygrps-yiv-388526850 {

font-family:Symbol;}
_filtered #ygrps-yiv-388526850 {

font-family:“Courier New”;
}
_filtered #ygrps-yiv-388526850 {

font-family:Wingdings;}
_filtered #ygrps-yiv-388526850 {

font-family:Wingdings;}
_filtered #ygrps-yiv-388526850 {

font-family:Wingdings;}
_filtered #ygrps-yiv-388526850 {

font-family:Wingdings;}
_filtered #ygrps-yiv-388526850 {

font-family:Wingdings;}
_filtered #ygrps-yiv-388526850 {

font-family:Wingdings;}
_filtered #ygrps-yiv-388526850 {

font-family:Wingdings;}
#ygrps-yiv-388526850 ol
{margin-bottom:0in;}
#ygrps-yiv-388526850 ul
{margin-bottom:0in;}
–>

Thank you, Sue. GRRR…  now this is 2 major things we need for dashboards that are “broken” in 9.05.702. Guess we will still be doing things in MS Access for the short-term… the other issue we had with BAQ’s we were told won’t be fixed until 10.01 estimated next spring…

2

I am on 9.05.702A progress – I am trying to write a BAQ on the quote which would summarize “expected” quote Amt (based on how WE calculate expected amount).

 

So to do this I need to be able to have an aggregate field which would total up an equation of the QuoteQty table multiplied by a field the QuoteDtl table.

 

When I try to do this I get ‘0’ even though it should return a number.

 

If I total up just one table it works, but I need the equation to include fields from both tables and then total that.

 

I can do this very easily in MS Access using subqueries.

 

Does anybody know if this can be done in BAQ and I am just missing something obvious?

 

Thanks,

Sarah

3
BAQs with "stacked" summary tables are broken in 9.05.702a. This is the information I have on the SCR for it.

SCR=116608, Part=ICE-BAQ, Description=BAQ designer - BAQ IsSummary doesn't calculate total correctly when multiple tables are summarized that have a 1 to many relations and are on different levels or nodes in the Phase Builder., Priority=IH, Severity=3 - Error Workaround, Type=Tools, Module=BAQD, Clientele ID=3091015ESC, Product=ICE-Tool, Status=Open

I was told this won't be fixed in 9.05.7xx as it requires a rebuild of the framework.

Sue