Bar chart question

[Arde]

Hi All,

Im trying to create a barchart that displays order backlog.

Main idea of the chart is that on current month it sums whole backlog {@total}.

Next month it shows whole backlog {@total} except those orders which {@shipday} is on the first month, and so on.

Basically I have the following fields:
{@shipday}=date when order is shipped.
{@total}=currency value of the shipment.

Is this possible to create?

Thanks for help.

 

[lbass]

Please show the content of your formulas (and of any nested formulas). Have you been able to create a formula that that deducts the value of shipments made in the previous month? If so, please show the content of that, also.

-LB

 

[Arde]

On details section are the order lines. They are grouped by Sale order number. {@total} is sum on Sale order number group.

I have following formulas:

{@Undelivered}:
If IsNull({Table.Delivered_Quantity}) Then
{TableElement.Quantity} Else
{TableElement.Quantity}-{TableElement.Delivered_Quantity}

{@total}:
{@Undelivered}*({TableElement.Cost}/{TableElement.SO_Rate})

//This is used to remove the delivered lines. Is equal to "UnDelivered"
{@Quantity-DeliveredQuantity}:
If IsNull({TableElement.Delivered_Quantity}) Or
{TableElement.Delivered_Quantity}=0 Or
{TableElement.Quantity}-{TableElement.Delivered_Quantity}>0 Then "UnDelivered"
Else "Delivered"


{@Shipday}:
If
DateSerial(year({TableElement.ReqTermDate}), month({TableElement.ReqTermDate}),1)
<
DateSerial(Year(currentdate),Month(currentdate),1)
Then currentdate else
{TableElement.ReqTermDate}

I havent been able to make formula that detucts the value of shipments of previous months.

 

[Arde]

In Excel this can be done by sumproduct. I am just wondering if this is possible by Crystal?