TOTAL VALUE not working

[Cherrel]

Greetings and Salutations to All!

Here is my issue. I am composing a report that gives a basic status report on Inventory currently on-hand. Besides running the report off of Model Numbers (1), the report contains five additional fields - Ready for Issue (not broken) (2), Not Ready for Issue (broken) (3), Total (sum of fields 2 & 3) (4), and TOTAL VALUE (sum of field 4 multiplied by inventory cost - supplied by field ITEM.IN5) (5).

I am unable to get my TOTAL VALUE to function. I have the formula as: ({@SUM OF A & F} * {item.in5})

***
I have an inventory item, it's name is ABC-123. I have 2 RFI and 1 NRFI. Each individual part is worth $200.00 Should produce me a total value of $600.00 -- alas, it produces me the original cost of $200.00

EXAMPLE:

(CURRENTLY PRODUCES)
MODEL RFI NRFI TOTAL TOTAL VALUE
----- --- ---- ----- -----------
ABC-123 2 1 3 $200.00

(SHOULD PRODUCE)

MODEL RFI NRFI TOTAL TOTAL VALUE
----- --- ---- ----- -----------
ABC-123 2 1 3 $600.00

Thanks everyone!!! X-)
Cherrel.

 

[Nuffsaid]

Hi Cherrel,

If I read this right, shouldn't the formula be,
{field.4} which is total units * {field.5} which is unit price, so 3 x 200 = 600 ?

Nuffsaid.

 

[Cherrel]

Nuffsaid,

You are correct. The formula you provided and my formula is supposed to produce the same answer.

Cherrel. %-)

 

[dgillz]

Cherrel,

If you use the following forumla is it still giving you bad results?

({A}+{F})*{item.in5}

Note that there is no need to do a sum here. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office

 

[Cherrel]

dgillz,

I set-up the formula as you suggested and I am still getting the cost for only one of the inventory items. :-(

? ? ?

Cherrel.

 

[Nuffsaid]

O.K. dumb question time.....

Are all fields and formulas in the detail section?

Are you 100% sure that the information within your fields is correct?

Nuffsaid.

 

[dgillz]

Do a formula ({A}+{F}) and make sure the answer is not 1. Software Support for Sage Mas90, Macola, Crystal Reports, Goldmine and MS Office