Crystal 2008 if then else


(system) #1
Don't think I have an outer join for ordermsc will look tomorrow.

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;"> &nbsp;</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?&nbsp; Do you have left out join for the OrderMsc.?</span></p><p class="ygrps-yiv-1654980013MsoNormal"><span style="font-size:11.0pt;color:#1F497D;"> &nbsp;</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;"> &nbsp;</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"> &nbsp;</p><p class="ygrps-yiv-1654980013MsoNormal">&nbsp; </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&#39;t this handle the Null??</strong></p></div><div><p class="ygrps-yiv-1654980013MsoNormal">&nbsp;</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"> &nbsp;</p><div><p class="ygrps-yiv-1654980013MsoNormal">On Sun, Sep 22, 2013 at 8:08 PM, Vantage &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@...">vantage@...</a>&gt; wrote:</p><div><p class="ygrps-yiv-1654980013MsoNormal">&nbsp; </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;">&nbsp;</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">&nbsp;</p><p class="ygrps-yiv-1654980013MsoNormal">&nbsp; </p><div><div><div><div><div><div><p class="ygrps-yiv-1654980013MsoNormal">Ok, got it in a formula field and it doesn&#39;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, &quot;Vantage&quot; &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@...">vantage@...</a>&gt; wrote:</p></div><blockquote><div><p class="ygrps-yiv-1654980013MsoNormal">&nbsp; </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 &quot;a Boolean required<br>here&quot;<br><br>if({Customer.CheckBox05}=&quot;True&quot;) 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>, &quot;Vantage&quot; &lt;<a rel="nofollow" target="_blank" href="mailto:vantage@...">vantage@...</a>&gt; wrote:<br>&gt;<br>&gt; Remove the totext around the Customer.CheckBox05<br>&gt; <br>&gt; <br>&gt; <br>&gt; 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>&gt; jamesd<br>&gt; Sent: Saturday, September 21, 2013 1:56 PM<br>&gt; To: <a rel="nofollow" target="_blank" href="mailto:vantage@yahoogroups.com">vantage@yahoogroups.com</a><br>&gt; Subject: [Vantage] Crystal 2008 if then else<br>&gt; <br>&gt; <br>&gt; <br>&gt; <br>&gt; <br>&gt; Trying to add misc charge to doc unit price if checkbox is true other wise<br>&gt; just show doc unit price. on save I get an error &quot;a Boolean required here&quot;<br>&gt; <br>&gt; if(totext({Customer.CheckBox05})=&quot;True&quot;) then ({OrderDtl.DocUnitPrice} +<br>&gt; {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}<br>&gt; <br>&gt; <br>&gt; <br><br><br></p></div></div></blockquote></div></div></div></div></div></div></div></div></div></div></div><p class="ygrps-yiv-1654980013MsoNormal"> &nbsp;</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&amp;m=4194e7e56b32&amp;t=20130923&amp;c=s">Spam</a></span></p></div></div></div></div><p></p>

</div>

(system) #2
Trying to add misc charge to doc unit price if checkbox is true other wise just show doc unit price. on save I get an error "a Boolean required here"

if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} + {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

(system) #3

Remove the totext around the Customer.CheckBox05

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of jamesd
Sent: Saturday, September 21, 2013 1:56 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal 2008 if then else

 

 

Trying to add misc charge to doc unit price if checkbox is true other wise just show doc unit price. on save I get an error "a Boolean required here"

if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} + {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}


(system) #4
changed to remove totext as below and still get error "a Boolean required here"

if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} + {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

--- In vantage@yahoogroups.com, "Vantage" <vantage@...> wrote:
>
> Remove the totext around the Customer.CheckBox05
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
> jamesd
> Sent: Saturday, September 21, 2013 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2008 if then else
>
>
>
>
>
> Trying to add misc charge to doc unit price if checkbox is true other wise
> just show doc unit price. on save I get an error "a Boolean required here"
>
> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +
> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}
>
>
>
> _____
>
>
> Spam
> <https://antispam.roaringpenguin.com/canit/b.php?i=0aKrSTOGH&m=475085a32a14&
> t=20130921&c=s>
>

(system) #5
This should work.



if{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}



You may have to add below if there is no misc line.



if isnull({OrderMsc.MiscAmt}) then {OrderDtl.DocUnitPrice} else if
{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}



Steve



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jamesd
Sent: Saturday, September 21, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2008 if then else





changed to remove totext as below and still get error "a Boolean required
here"

if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

--- In vantage@yahoogroups.com, "Vantage" <vantage@...> wrote:
>
> Remove the totext around the Customer.CheckBox05
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> jamesd
> Sent: Saturday, September 21, 2013 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2008 if then else
>
>
>
>
>
> Trying to add misc charge to doc unit price if checkbox is true other wise
> just show doc unit price. on save I get an error "a Boolean required here"
>
> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +
> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}
>
>
>
> _____
>
>
> Spam
>
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrSTOGH&m=475085a32a14&
> t=20130921&c=s>
>



_____


Spam
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrV3dIu&m=781630f206c5&
t=20130921&c=s>



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

(system) #6
Tried both and still get Boolean error.. Maybe this needs to go in something other than the fiel suppress formula?

Sent from my iPad

On Sep 21, 2013, at 5:34 PM, "Vantage" <vantage@...> wrote:

 

<div id="ygrps-yiv-1905673850ygrp-text">
  
  
  <p>This should work.<br>

if{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

You may have to add below if there is no misc line.

if isnull({OrderMsc.MiscAmt}) then {OrderDtl.DocUnitPrice} else if
{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

Steve

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jamesd
Sent: Saturday, September 21, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2008 if then else

changed to remove totext as below and still get error "a Boolean required
here"

if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

--- In vantage@yahoogroups.com, "Vantage" <vantage@...> wrote:
>
> Remove the totext around the Customer.CheckBox05
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> jamesd
> Sent: Saturday, September 21, 2013 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2008 if then else
>
>
>
>
>
> Trying to add misc charge to doc unit price if checkbox is true other wise
> just show doc unit price. on save I get an error "a Boolean required here"
>
> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +
> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}
>
>
>
> _____
>
>
> Spam
>
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrSTOGH&m=475085a32a14&
> t=20130921&c=s>
>

_____

Spam
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrV3dIu&m=781630f206c5&
t=20130921&c=s>

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

</div>

(system) #7
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?

Sent from my iPad

On Sep 21, 2013, at 5:34 PM, "Vantage" <vantage@...> wrote:

 

<div id="ygrps-yiv-256990351ygrp-text">
  
  
  <p>This should work.<br>

if{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

You may have to add below if there is no misc line.

if isnull({OrderMsc.MiscAmt}) then {OrderDtl.DocUnitPrice} else if
{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

Steve

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jamesd
Sent: Saturday, September 21, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2008 if then else

changed to remove totext as below and still get error "a Boolean required
here"

if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

--- In vantage@yahoogroups.com, "Vantage" <vantage@...> wrote:
>
> Remove the totext around the Customer.CheckBox05
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> jamesd
> Sent: Saturday, September 21, 2013 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2008 if then else
>
>
>
>
>
> Trying to add misc charge to doc unit price if checkbox is true other wise
> just show doc unit price. on save I get an error "a Boolean required here"
>
> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +
> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}
>
>
>
> _____
>
>
> Spam
>
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrSTOGH&m=475085a32a14&
> t=20130921&c=s>
>

_____

Spam
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrV3dIu&m=781630f206c5&
t=20130921&c=s>

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

</div>

(system) #8

That is because there is no misc. on one of the detail lines. Null field

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Daniel
Sent: Sunday, September 22, 2013 4:06 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal 2008 if then else

 

 

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?

Sent from my iPad


On Sep 21, 2013, at 5:34 PM, "Vantage" <vantage@...> wrote:

 

This should work.

if{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

You may have to add below if there is no misc line.

if isnull({OrderMsc.MiscAmt}) then {OrderDtl.DocUnitPrice} else if
{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

Steve

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jamesd
Sent: Saturday, September 21, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2008 if then else

changed to remove totext as below and still get error "a Boolean required
here"

if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

--- In vantage@yahoogroups.com, "Vantage" <vantage@...> wrote:
>
> Remove the totext around the Customer.CheckBox05
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> jamesd
> Sent: Saturday, September 21, 2013 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2008 if then else
>
>
>
>
>
> Trying to add misc charge to doc unit price if checkbox is true other wise
> just show doc unit price. on save I get an error "a Boolean required here"
>
> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +
> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}
>
>
>
> _____
>
>
> Spam
>
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrSTOGH&m=475085a32a14&
> t=20130921&c=s>
>

_____

Spam
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrV3dIu&m=781630f206c5&
t=20130921&c=s>

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


(system) #9
doesn't this handle the Null??
Â
if isnull({ordermsc.miscamt}) then {orderdtl.docunitprice}else if{Customer.CheckBox05}=True then({OrderDtl.DocUnitPrice} + {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}


On Sun, Sep 22, 2013 at 8:08 PM, Vantage <vantage@...> wrote:

Â
<div>
  
  
  <p><div><p class="ygrps-yiv-1780620622MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt;">That is because there is no misc. on one of the detail lines. Null field<u></u><u></u></span></p><p class="ygrps-yiv-1780620622MsoNormal"><span style="color:rgb(31,73,125);font-size:11pt;"><u></u>Â <u></u></span></p>

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Daniel
Sent: Sunday, September 22, 2013 4:06 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal 2008 if then else

Â

Â

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?

Sent from my iPad


On Sep 21, 2013, at 5:34 PM, "Vantage" <vantage@...> wrote:

Â

This should work.

if{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

You may have to add below if there is no misc line.

if isnull({OrderMsc.MiscAmt}) then {OrderDtl.DocUnitPrice} else if
{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

Steve

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jamesd
Sent: Saturday, September 21, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2008 if then else

changed to remove totext as below and still get error "a Boolean required
here"

if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

--- In vantage@yahoogroups.com, "Vantage" <vantage@...> wrote:
>
> Remove the totext around the Customer.CheckBox05
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> jamesd
> Sent: Saturday, September 21, 2013 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2008 if then else
>
>
>
>
>
> Trying to add misc charge to doc unit price if checkbox is true other wise
> just show doc unit price. on save I get an error "a Boolean required here"
>
> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +
> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}
>
>
>
> _____
>
>
> Spam
>
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrSTOGH&m=475085a32a14&
> t=20130921&c=s>
>

_____

Spam
<https://antispam.roaringpenguin.com/canit/b.php?i=0aKrV3dIu&m=781630f206c5&
t=20130921&c=s>

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

</div>
 


<div style="color:rgb(255,255,255);min-height:0px;"></div>


(system) #10

James,

 

Tested it and it works fine how do you have the tables linked?  Do you have left out join for the OrderMsc.?

 

Steve

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of james daniel
Sent: Monday, September 23, 2013 4:47 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal 2008 if then else

 

 

doesn't this handle the Null??

 

if isnull({ordermsc.miscamt}) then {orderdtl.docunitprice}else if{Customer.CheckBox05}=True then({OrderDtl.DocUnitPrice} + {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

 

On Sun, Sep 22, 2013 at 8:08 PM, Vantage <vantage@...> wrote:

 

That is because there is no misc. on one of the detail lines. Null field

 

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of James Daniel
Sent: Sunday, September 22, 2013 4:06 PM
To: vantage@yahoogroups.com
Subject: Re: [Vantage] Re: Crystal 2008 if then else

 

 

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?

Sent from my iPad


On Sep 21, 2013, at 5:34 PM, "Vantage" <vantage@...> wrote:

 

This should work.

if{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

You may have to add below if there is no misc line.

if isnull({OrderMsc.MiscAmt}) then {OrderDtl.DocUnitPrice} else if
{Customer.CheckBox05}=True then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

Steve

From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf Of
jamesd
Sent: Saturday, September 21, 2013 4:03 PM
To: vantage@yahoogroups.com
Subject: [Vantage] Re: Crystal 2008 if then else

changed to remove totext as below and still get error "a Boolean required
here"

if({Customer.CheckBox05}="True") then ({OrderDtl.DocUnitPrice} +
{OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}

--- In vantage@yahoogroups.com, "Vantage" <vantage@...> wrote:
>
> Remove the totext around the Customer.CheckBox05
>
>
>
> From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of
> jamesd
> Sent: Saturday, September 21, 2013 1:56 PM
> To: vantage@yahoogroups.com
> Subject: [Vantage] Crystal 2008 if then else
>
>
>
>
>
> Trying to add misc charge to doc unit price if checkbox is true other wise
> just show doc unit price. on save I get an error "a Boolean required here"
>
> if(totext({Customer.CheckBox05})="True") then ({OrderDtl.DocUnitPrice} +
> {OrderMsc.MiscAmt}) else {OrderDtl.DocUnitPrice}
>
>
>