Flowfield based on a flowfield

jhanvincent14

Hello, Good day, I have created a TableOne and one of the field(decimal) is a flowfield base on TableTwo's field(decimal) and that's also is a flowfield based on TableThree's decimal field.

Now, my problem is, If I run the TableOne, I keep getting this error (see picture attached). Actual amount field is in TableTwo that is based on TableThree's Amount field. and if I run the TableTwo, it is perfectly running. Now, If I run TableOne, this error is keep on showing and it closes the page.

Hope you can help me. thank you in advance..

Slawek_Guzek

Hi,

Unfortunately it is impossible to have a Flowfield summing up values in another Flowfield.

You need to redefine your Table1 flowfieldto sum up Amount filed directly from Table3

Slawek

Slawek_Guzek

Hi,

Unfortunately it is impossible to have a Flowfield summing up values in another Flowfield.

You need to redefine your Table1 flowfieldto sum up Amount filed directly from Table3

Slawek

guidorobben

Build a query. With a query you can sum a flowfield.

Slawek_Guzek

guidorobben wrote: »

Build a query. With a query you can sum a flowfield.

A page cannot be based on a query.

guidorobben

Slawek_Guzek wrote: »

guidorobben wrote: »

Build a query. With a query you can sum a flowfield.

A page cannot be based on a query.

True. Run it by code. MS does this also.

Juhl

Make a table and a page, as temporary. Fill the table from the query in OnOpen.
So it is possible.

If you only need some data/sum then skip the page, and fill the table in the query.

Slawek_Guzek

Sure. In very the same way it is possible to build a page based on Excel spreadsheet.

RockWithNAV

Still thinking how come you got this business process in particular, and why to do lookup of a flow field for another flow field, you can apply the the same calcformula for both the columns.

jhanvincent14

To All who gave comments, thank you, I appreciated it

jhanvincent14

Slawek_Guzek wrote: »

Hi,

Unfortunately it is impossible to have a Flowfield summing up values in another Flowfield.

You need to redefine your Table1 flowfieldto sum up Amount filed directly from Table3

Slawek

Thank you, this works. God speed @Slawek_Guzek