Sum fields in the same table

karuchua

hi all,

am trying to sum an amount field but not working.

i have created a variable xx and it has flowfield of type sum.

i have assigned the amount in the sumindexfields of the same table.

but my field xx seems not to be updated..

wot is wrong here?

Savatage

is this amount field a flowfield too?

Sounds like you create a flowfield of a flowfield.

is this correct? is this a report? you need to provide more info.

or perhaps look at the CALCFIELDS property:

FlowFields are virtual fields. The values in these fields are not saved in the table. This means that you must use the CALCFIELDS function to update them.

http://msdn.microsoft.com/en-us/library/dd338975.aspx

karuchua

basically am trying to total an amount field in a table line. that is total all the amount in the lines and update in the total field.

Savatage

I understand what you are trying to do but re-read your own post.

am trying to total an amount field in a table line. that is total all the amount in the lines and update in the total field.

Now are you trying to total up lines that "have" an amount field.

but where do you want to show this? a report? a form? a what?

by what you posted it sounds like you want to add up lines and post that total in the same table?

now, are your adding up lines & want the total amount is some other header table?

by your quote it sounds like each sales line has an amount & total field on the same line..where is this total field you speak of? understand my confusion?

Have you created flowfields before?