Crystal Formula Issue

Yahoo Archive
1
Tell everyone what it was.



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Monday, May 04, 2009 12:24 PM
To: vantage@yahoogroups.com
Subject: RE: [Vantage] Crystal Formula Issue








Charlie your solution worked!

Thanks,

From: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
[mailto:vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com> ] On
Behalf
Of Late, Travis
Sent: Monday, May 04, 2009 10:43 AM
To: vantage@yahoogroups.com <mailto:vantage%40yahoogroups.com>
Subject: [Vantage] Crystal Formula Issue

This question is regarding a Daily Backlog Report that I have created in
crystal. The problem I'm getting is the report is not calculating the
discount percentage. This is the formula that I am using to get this
number. I'm guessing my formula is off somewhere, but I can't seem to
figure it out. Here is the formula that I am using for this:

iif({ShipDtl.OurInventoryShipQty} > 0,({OrderDtl.OrderQty} -
{ShipDtl.OurInventoryShipQty}) * {OrderDtl.UnitPrice} *
(1-({OrderDtl.DiscountPercent} / 100)),{OrderDtl.UnitPrice} *
{OrderDtl.OrderQty})

Thanks in advance,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate%40m-bco.com> >

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

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





[Non-text portions of this message have been removed]
2
This question is regarding a Daily Backlog Report that I have created in
crystal. The problem I'm getting is the report is not calculating the
discount percentage. This is the formula that I am using to get this
number. I'm guessing my formula is off somewhere, but I can't seem to
figure it out. Here is the formula that I am using for this:



iif({ShipDtl.OurInventoryShipQty} > 0,({OrderDtl.OrderQty} -
{ShipDtl.OurInventoryShipQty}) * {OrderDtl.UnitPrice} *
(1-({OrderDtl.DiscountPercent} / 100)),{OrderDtl.UnitPrice} *
{OrderDtl.OrderQty})



Thanks in advance,



Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate@...>





[Non-text portions of this message have been removed]
3
Charlie your solution worked!



Thanks,



From: vantage@yahoogroups.com [mailto:vantage@yahoogroups.com] On Behalf
Of Late, Travis
Sent: Monday, May 04, 2009 10:43 AM
To: vantage@yahoogroups.com
Subject: [Vantage] Crystal Formula Issue








This question is regarding a Daily Backlog Report that I have created in
crystal. The problem I'm getting is the report is not calculating the
discount percentage. This is the formula that I am using to get this
number. I'm guessing my formula is off somewhere, but I can't seem to
figure it out. Here is the formula that I am using for this:

iif({ShipDtl.OurInventoryShipQty} > 0,({OrderDtl.OrderQty} -
{ShipDtl.OurInventoryShipQty}) * {OrderDtl.UnitPrice} *
(1-({OrderDtl.DiscountPercent} / 100)),{OrderDtl.UnitPrice} *
{OrderDtl.OrderQty})

Thanks in advance,

Travis Late

ERP Project Manager

M-B Companies, Inc

1200 Park Street

Chilton, WI 53014

Phone: 920-898-1560 Ext.152

Cell: 920-960-0062

Email: tlate@... <mailto:tlate%40m-bco.com>
<mailto:tlate@... <mailto:tlate%40m-bco.com> >

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





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