array formula

[mbDutch]

Question.

My (3rd party) database contains 3 arrayed field.
Qty Shipped
Qty Ordered
Retail price

I need the 3rd section out of each array so I've created formulas for these fields to split them with
the ToNumber(Split({fieldname}, ";")[3]) formula.

Now I have created an additional formula {@Price} that contains {@QtyShipped} * {@Retail price} but for some odd reason it does not give me the correct results.
For instance 305880 units shipped * 0.11 cts should be
33646.8 but instead it gives 34105.62

I'm so lost. Any idea what I may be doing wrong?

As always, many thanks for your help in advance!

Marco

 

[lbass]

Please show a sample of how the data displays in the detail section before you use the split formula.

-LB