Splitting cell into 2

[Arde]

Hi,

Can one data cell be separated into two cells?

I am making a report where partly delivered saleorders needs to be in both confirmed and delivered saleorders.

Example:
Saleorder number is x and saleorder total is 10$ where delivered amount is 6$. 4$ needs to be in confirmed saleorders group and 6$ needs to be in delivered saleorders group. Both in the same saleorder number.

What is the best practise to do this.

 

[kskid]

You can create formulas to handle

//@DeliveredAmount
{table.salesordr}*.4

//@SalesOrderGrp
{table.salesordr} - @DeliveredAmount

 

[lbass]

How do you know the amount in the delivered vs. confirmed categories? Is there a field that distinguishes the amounts?

-LB

 

[Arde]

The fields that i have or I can count are.
{@deliveredAmount}
{@UndliveredAmount}
{@SaleOrderNumber}
SaleOrder.status (1=confirmed, 2=partly delivered, 3=delivered)
etc.

I tried to use the SaleOrder.status as to group the orders, but I can't figure how the {@deliveredAmount} and
{@UndliveredAmount} can be in both places at once (status 1 and 2).

Help needed, I have figured out this for too long and i am stuck.

 

[kskid]

Please show the contents of your formulas.

 

[chelseatech]

I'd use a formula for confirmed of
if {SaleOrder.status} = 1 then {@SaleOrderNumber}

and for Partly deliverd of
if {SaleOrder.status} = 2 then {@SaleOrderNumber}

What are you wanting to do? if it is jsut a count then use
if {SaleOrder.status} = 1 then 1

then sum that column.

Editor and Publisher of Crystal Clear

http://www.chelseatech.co.nz/pubs.htm

 

[Arde]

So, the basic idea is to look each order by saleordernumber and group them by confirmed and delivered orders.
ie.
saleordernumber customername subtotal profits date

confirmed group
100 Custname 4$ 30% 2009.1.1

delivered group
100 Custname 6$ 30% 2009.1.1

 

[lbass]

As already requested, please show the contents of your formulas (and any formulas nested within them).

-LB