I got it figured out.
I am working on an excess material on order report and can't get the summary of supply and demand from partdtl
I want the summary of the supply and demand records for a part from PartDtl. I can get one or the other, but when I add partdtl table a second time I get incorrect results on the first table.
I tried a condition al value (if PartDtl.RequirementFlag = true then PartDtl.Quantity else 0) and then totaling that, but no luck.
If someone has a working baq they would be willing to share or idea about how I can sum both of these, I would be most appreciative.
Greg Payne
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]
I want the summary of the supply and demand records for a part from PartDtl. I can get one or the other, but when I add partdtl table a second time I get incorrect results on the first table.
I tried a condition al value (if PartDtl.RequirementFlag = true then PartDtl.Quantity else 0) and then totaling that, but no luck.
If someone has a working baq they would be willing to share or idea about how I can sum both of these, I would be most appreciative.
Greg Payne
________________________________
CONFIDENTIALITY NOTICE
The information contained in this communication, including attachments, is privileged and confidential. It is intended only for the exclusive use of the addressee. If the reader of this message is not the intended recipient, or the employee or agent responsible for delivering it to the intended recipient, you are hereby notified that any dissemination, distribution or copying of this communication is strictly prohibited. If you have received this communication in error, please notify us at 727-578-6280 and immediately delete the communication.
"This (document/presentation) may contain technical data as defined in the International Traffic In Arms Regulations (ITAR) 22 CFR 120.10. Export of this material is restricted by the Arms Export Control Act (22 U.S.C. 2751 et seq.) and may not be exported to foreign persons without prior approval form the U.S. Department of State."
[Non-text portions of this message have been removed]
I have a calculated field in a BAQ that is not returning the correct results. Here is what I have but I have many parts with BLANK TranDates.
If PartTran.TranDate =
11/26/2013 then
11/26/2013 then
Part.Date20
ELSE IF PartTran.TranDate =
11/25/2013 then
11/25/2013 then
Part.Date20
Else if PartTran.TranDate =11/27/2013 then
Part.Date20
Else If PartTran.TranDate >
Part.Date20 Then
Part.Date20 Then
PartTran.TranDate Else
Part.Date20
(sorry for format)
I think I need to add if Part.Date20 is NULL then PartTran.TranDate.
I want to add Else If Part.Date20 is NULL Then PartTran.TranDate. But I can’t seem to get the syntax correct.
Any thoughts?
This works for me in 905.606:
If IsNull(Part.Date20) Then
PartTran.TranDate
Else If (PartTran.TranDate >= 11/25/2013 and PartTran.TranDate <= 11/27/2013) then
Part.Date20
Else If PartTran.TranDate > Part.Date20 Then
PartTran.TranDate
Else
Part.Date20
But you mentioned null TranDates at the beginning, then tried to add a check for null Date20. Do you mean this instead?
If IsNull(PartTran.TranDate) Then
Part.Date20
Else If (PartTran.TranDate >= 11/25/2013 and PartTran.TranDate <= 11/27/2013) then
Part.Date20
Else If PartTran.TranDate > Part.Date20 Then
PartTran.TranDate
Else
Part.Date20
The first...sorry.
I tried what works for you but I am getting the following error when I check the Syntax
"There is a syntax or data type conversion error in 'LastActivityDate' calculated field expression.
On Wednesday, April 29, 2015 9:49 AM, "akgillis@... [vantage]" <vantage@yahoogroups.com> wrote:
<div id="ygrps-yiv-1202547067yiv0189051701ygrp-text">
<div>This works for me in 905.606:</div><div><br clear="none"></div><div><div>If IsNull(Part.Date20) Then</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="white-space:pre;"> </span>PartTran.TranDate</div><div>Else If (PartTran.TranDate >= 11/25/2013 and PartTran.TranDate <= 11/27/2013) then</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="white-space:pre;"> </span>Part.Date20</div><div>Else If PartTran.TranDate > Part.Date20 Then</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="word-spacing:normal;white-space:pre;"> </span>PartTran.TranDate</div><div>Else</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="white-space:pre;"> </span>Part.Date20</div></div><div><br clear="none"></div><div>But you mentioned null TranDates at the beginning, then tried to add a check for null Date20. Do you mean this instead?</div><div><br clear="none"></div><div><div>If IsNull(PartTran.TranDate) Then</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="white-space:pre;"> </span><span style="word-spacing:normal;">Part.Date20</span></div><div>Else If (PartTran.TranDate >= 11/25/2013 and PartTran.TranDate <= 11/27/2013) then</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="white-space:pre;"> </span>Part.Date20</div><div>Else If PartTran.TranDate > Part.Date20 Then</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="word-spacing:normal;white-space:pre;"> </span>PartTran.TranDate</div><div>Else</div><div><span class="ygrps-yiv-1202547067yiv0189051701Apple-tab-span" style="white-space:pre;"> </span>Part.Date20</div></div><div><br clear="none"></div>
</div>
<div style="height:0px;color:rgb(255, 255, 255);"></div></div>
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mkp hr {
border:1px solid #d8d8d8;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mkp #ygrps-yiv-1202547067yiv0189051701hd {
color:#628c2a;font-size:85%;font-weight:700;line-height:122%;margin:10px 0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mkp #ygrps-yiv-1202547067yiv0189051701ads {
margin-bottom:10px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mkp .ygrps-yiv-1202547067yiv0189051701ad {
padding:0 0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mkp .ygrps-yiv-1202547067yiv0189051701ad p {
margin:0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mkp .ygrps-yiv-1202547067yiv0189051701ad a {
color:#0000ff;text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-sponsor #ygrps-yiv-1202547067yiv0189051701ygrp-lc {
font-family:Arial;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-sponsor #ygrps-yiv-1202547067yiv0189051701ygrp-lc #ygrps-yiv-1202547067yiv0189051701hd {
margin:10px 0px;font-weight:700;font-size:78%;line-height:122%;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-sponsor #ygrps-yiv-1202547067yiv0189051701ygrp-lc .ygrps-yiv-1202547067yiv0189051701ad {
margin-bottom:10px;padding:0 0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701actions {
font-family:Verdana;font-size:11px;padding:10px 0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701activity {
background-color:#e0ecee;float:left;font-family:Verdana;font-size:10px;padding:10px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701activity span {
font-weight:700;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701activity span:first-child {
text-transform:uppercase;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701activity span a {
color:#5085b6;text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701activity span span {
color:#ff7900;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701activity span .ygrps-yiv-1202547067yiv0189051701underline {
text-decoration:underline;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701attach {
clear:both;display:table;font-family:Arial;font-size:12px;padding:10px 0;width:400px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701attach div a {
text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701attach img {
border:none;padding-right:5px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701attach label {
display:block;margin-bottom:5px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701attach label a {
text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 blockquote {
margin:0 0 0 4px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701bold {
font-family:Arial;font-size:13px;font-weight:700;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701bold a {
text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 dd.ygrps-yiv-1202547067yiv0189051701last p a {
font-family:Verdana;font-weight:700;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 dd.ygrps-yiv-1202547067yiv0189051701last p span {
margin-right:10px;font-family:Verdana;font-weight:700;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 dd.ygrps-yiv-1202547067yiv0189051701last p span.ygrps-yiv-1202547067yiv0189051701yshortcuts {
margin-right:0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701attach-table div div a {
text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701attach-table {
width:400px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701file-title a, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701file-title a:active, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701file-title a:hover, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701file-title a:visited {
text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701photo-title a, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701photo-title a:active, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701photo-title a:hover, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div.ygrps-yiv-1202547067yiv0189051701photo-title a:visited {
text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 div#ygrps-yiv-1202547067yiv0189051701ygrp-mlmsg #ygrps-yiv-1202547067yiv0189051701ygrp-msg p a span.ygrps-yiv-1202547067yiv0189051701yshortcuts {
font-family:Verdana;font-size:10px;font-weight:normal;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701green {
color:#628c2a;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701MsoNormal {
margin:0 0 0 0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 o {
font-size:0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701photos div {
float:left;width:72px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701photos div div {
border:1px solid #666666;height:62px;overflow:hidden;width:62px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701photos div label {
color:#666666;font-size:10px;overflow:hidden;text-align:center;white-space:nowrap;width:64px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701reco-category {
font-size:77%;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701reco-desc {
font-size:77%;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 .ygrps-yiv-1202547067yiv0189051701replbq {
margin:4px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-actbar div a:first-child {
margin-right:2px;padding-right:5px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mlmsg {
font-size:13px;font-family:Arial, helvetica, clean, sans-serif;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mlmsg table {
font-size:inherit;font:100%;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mlmsg select, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 input, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 textarea {
font:99% Arial, Helvetica, clean, sans-serif;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mlmsg pre, #ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 code {
font:115% monospace;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mlmsg * {
line-height:1.22em;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-mlmsg #ygrps-yiv-1202547067yiv0189051701logo {
padding-bottom:10px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-msg p a {
font-family:Verdana;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-msg p#ygrps-yiv-1202547067yiv0189051701attach-count span {
color:#1E66AE;font-weight:700;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-reco #ygrps-yiv-1202547067yiv0189051701reco-head {
color:#ff7900;font-weight:700;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-reco {
margin-bottom:20px;padding:0px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-sponsor #ygrps-yiv-1202547067yiv0189051701ov li a {
font-size:130%;text-decoration:none;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-sponsor #ygrps-yiv-1202547067yiv0189051701ov li {
font-size:77%;list-style-type:square;padding:6px 0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-sponsor #ygrps-yiv-1202547067yiv0189051701ov ul {
margin:0;padding:0 0 0 8px;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-text {
font-family:Georgia;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-text p {
margin:0 0 1em 0;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-text tt {
font-size:120%;}
#ygrps-yiv-1202547067 #ygrps-yiv-1202547067yiv0189051701 #ygrps-yiv-1202547067yiv0189051701ygrp-vital ul li:last-child {
border-right:none !important;}
#ygrps-yiv-1202547067
What version are you running? Can you test a simpler expression to confirm the IsNull is causing the error?
If the expression will work without the isnull then try checking for null values by seeing if the date is greater than a fixed date like 01/01/1980.
Patrick Winter
From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com]
Sent: Thursday, April 30, 2015 07:10
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: BAQ Calculated field
What version are you running? Can you test a simpler expression to confirm the IsNull is causing the error?