Don't think I have an outer join for ordermsc will look tomorrow.
Sent from my iPad
Sent from my iPad
On Sep 24, 2013, at 8:52 AM, "Steve" <vantage@...> wrote:
<div id="ygrps-yiv-1654980013ygrp-text"> <p></p><div class="ygrps-yiv-1654980013WordSection1"><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">James,</span></p><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></p><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Tested it and it works fine how do you have the tables linked? Do you have left out join for the OrderMsc.?</span></p><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></p><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">Steve</span></p><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></p><div><div style="border-top:solid #B5C4DF 1.0pt;"><p class="ygrps-yiv-1654980013MsoNormal"><b><span style="font-size:10.0pt;">From:</span></b><span style="font-size:10.0pt;"> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">mailto:vantage@yahoogroups.com</a>] <b>On Behalf Of </b>james daniel<br><b>Sent:</b> Monday, September 23, 2013 4:47 PM<br><b>To:</b> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br><b>Subject:</b> Re: [Vantage] Re: Crystal 2008 if then else</span></p></div></div><p class="ygrps-yiv-1654980013MsoNormal"> </p><p class="ygrps-yiv-1654980013MsoNormal"> </p><div id="ygrps-yiv-1654980013ygrp-mlmsg"><div id="ygrps-yiv-1654980013ygrp-msg"><div id="ygrps-yiv-1654980013ygrp-text"><div><div><p class="ygrps-yiv-1654980013MsoNormal"><strong>doesn't this handle the Null??</strong></p></div><div><p class="ygrps-yiv-1654980013MsoNormal"> </p></div><div><p class="ygrps-yiv-1654980013MsoNormal"><strong>if isnull({ordermsc.miscamt}) then {orderdtl.docunitprice}else if{Customer.CheckBox05}=True then({OrderDtl.DocUnitPrice} + {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}</strong></p></div></div><div><p class="ygrps-yiv-1654980013MsoNormal"> </p><div><p class="ygrps-yiv-1654980013MsoNormal">On Sun, Sep 22, 2013 at 8:08 PM, Vantage <<a rel="nofollow" target="_blank" href="mailto:vantage@...">vantage@...</a>> wrote:</p><div><p class="ygrps-yiv-1654980013MsoNormal"> </p><div><div><div><div><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;">That is because there is no misc. on one of the detail lines. Null field</span></p><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> </span></p><div><div style="border-top:solid #B5C4DF 1.0pt;"><p class="ygrps-yiv-1654980013MsoNormal"><b><span style="font-size:10.0pt;">From:</span></b><span style="font-size:10.0pt;"> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [mailto:<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>] <b>On Behalf Of </b>James Daniel<br><b>Sent:</b> Sunday, September 22, 2013 4:06 PM<br><b>To:</b> <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br><b>Subject:</b> Re: [Vantage] Re: Crystal 2008 if then else</span></p></div></div><p class="ygrps-yiv-1654980013MsoNormal"> </p><p class="ygrps-yiv-1654980013MsoNormal"> </p><div><div><div><div><div><div><p class="ygrps-yiv-1654980013MsoNormal">Ok, got it in a formula field and it doesn't error any more, now it blanks out all of the data on my sales order acknowledgement?<br><br>Sent from my iPad</p></div><div><p class="ygrps-yiv-1654980013MsoNormal"><br>On Sep 21, 2013, at 5:34 PM, "Vantage" <<a rel="nofollow" target="_blank" href="mailto:vantage@...">vantage@...</a>> wrote:</p></div><blockquote><div><p class="ygrps-yiv-1654980013MsoNormal"> </p><div><p>This should work.<br><br>if{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +<br>{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}<br><br>You may have to add below if there is no misc line.<br><br>if isnull({OrderMsc.MiscAmt}) then {OrderDtl.DocUnitPrice} else if<br>{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +<br>{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}<br><br>Steve<br><br>From: <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">mailto:vantage@yahoogroups.com</a>] On Behalf Of<br>jamesd<br>Sent: Saturday, September 21, 2013 4:03 PM<br>To: <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br>Subject: [Vantage] Re: Crystal 2008 if then else<br><br>changed to remove totext as below and still get error "a Boolean required<br>here"<br><br>if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} +<br>{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}<br><br>--- In <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a>, "Vantage" <<a rel="nofollow" target="_blank" href="mailto:vantage@...">vantage@...</a>> wrote:<br>><br>> Remove the totext around the Customer.CheckBox05<br>> <br>> <br>> <br>> From: <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a> [<a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">mailto:vantage@yahoogroups.com</a>] On Behalf<br>Of<br>> jamesd<br>> Sent: Saturday, September 21, 2013 1:56 PM<br>> To: <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br>> Subject: [Vantage] Crystal 2008 if then else<br>> <br>> <br>> <br>> <br>> <br>> Trying to add misc charge to doc unit price if checkbox is true other wise<br>> just show doc unit price. on save I get an error "a Boolean required here"<br>> <br>> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +<br>> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}<br>> <br>> <br>> <br><br><br></p></div></div></blockquote></div></div></div></div></div></div></div></div></div></div></div><p class="ygrps-yiv-1654980013MsoNormal"> </p></div></div><div><p class="ygrps-yiv-1654980013MsoNormal"><span style="color:white;"></span></p></div><div><div class="ygrps-yiv-1654980013MsoNormal" align="center" style="text-align:center;"><span style="font-size:13.5pt;color:black;background:white;"><hr size="2" width="100%" align="center"></span></div><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:13.5pt;color:black;background:white;"><br><a rel="nofollow" target="_blank" href="https://antispam.roaringpenguin.com/canit/b.php?i=0aKsJL7a4&m=4194e7e56b32&t=20130923&c=s">Spam</a></span></p></div></div></div></div><p></p> </div>