filtering on a field page that is holding a calculation of two flowfields

ycdev

Hello I have a field that is holding a calculation of another 2 flowfields, the value are calculated correctly inside my page but if the user filter on the field that is making those calculation it doesn't display nothing. can someone help me out pls

Juhl

You cant.
You could base the page on your own temp table and fill it on page open.
Then it works.

ycdev

Hello Juhl tks for answer me, so you are telling me that I should create a temp Record variable type of my table and then make something like
CALCFIELDS(Field1, Field2);
TemTable.FielResutlt := Field1 - Field2; and add that code to the Open PAge trigger?

Juhl

No, you make a page with your tabel, then set it to temporary.
Then in Open Page trigger you loop the real tabel at copy alle records/fields to the Rec of the Page, and also do the calculation as above. So you end up with a temp copy with calculated fields.

ycdev

Tks a lot that worked