Filter Trouble

[shonatina]

Dear All,

i have 15 fields in a table. the 15th field is total

i need to set the Total as

total = ( ( field1 + field 2 +…field 14) / 8 )

Please can any guide me in this:)

thanks:)

[Tony_Rizwan]

Hi Shona,

You can put your function on OnValidate of each field (1…14). But why would you need this??

Regards,

-TR-

[shonatina]

You can put your function on OnValidate of each field (1…14). But why would you need this??

Are you suggesting that i create an Global value Total and add the fields and paste the same code in all CAL of the fields?

i need to calculate the total for my table thats why i need it.

Thanks:)

[shonatina]

You can put your function on OnValidate of each field (1…14). But why would you need this??

Are you suggesting that i create an Global value Total and add the fields and paste the same code in all CAL of the fields?

i need to calculate the total for my table thats why i need it.

Thanks:)

[shonatina]

sorry some default message said my post As not been posted so posted the same again.

thanks:)

[Tony_Rizwan]

Are you suggesting that i create an Global value Total

You mean Global Variable?? Not necessarily.

and paste the same code in all CAL of the fields

I’m afraid so.

I was just wondering why don’t you use a form or report to get the total of your table. If you do this, you will only create a function once and assign it as your SourceExpr(ession)

Regards,

-TR-

[shonatina]

I was just wondering why don’t you use a form or report to get the total of your table. If you do this, you will only create a function once and assign it as your SourceExpr(ession)

can you explain about this please:) 'm using form.

thanks:)

[Tony_Rizwan]

1. Create a form (List or Card whichever you prefer), I will use list
2. Add all the fields (1 to 14) to the form
3. Create a function Total with a Decimal return value. Put the summation in this function, don’t forget to return a value _use EXIT
4. Add one Text box and put Total as the SourceExpr
5. There you have it [:D]

[shonatina]

6470.tot.bmp (2.25 MB)

oh i have created a list form and have 15 fields. since its like i want the total of each row. so cant use the text box right? i have a field called total like this.

[Tony_Rizwan]

1. Create a form (List or Card whichever you prefer), I will use list
2. Add all the fields (1 to 14) to the form
3. Create a function Total with a Decimal return value. Put the summation in this function, don’t forget to return a value _use EXIT
4. Add one Text box and put Total as the SourceExpr
5. There you have it

But have you tried this??

[shonatina]

yes i changed the one i previously created as you said! stil i cant seem to get the result.

[Tony_Rizwan]

Create a function Total with a Decimal return value. Put the summation in this function, don’t forget to return a value _use EXIT

Total () :Decimal

l_Total ==> Local Var

l_Total := 1 + 2 + 3 + …+14; //This 1 2 3 referring to your Field Name

EXIT(l_Total)

Add one Text box and put Total as the SourceExpr

Regards,

-TR-

[shonatina]

hey tony thank for all your help. have solved my trouble.

Instead of Rec.field i was using xRec.field. that was the problem:)

[shonatina]

oh i just used the fields name its like this.

Field15 := ((field 1 + …+field 14 ) / 8)

but thanks:)