Problem with a sum field

Leroy

Hello, I have a table in where I have defined a Decimal type field and like Flowfield that makes the accumulated sum of another field.
Soon there is another Boolean type field that blocks or unblocks the line. I want that when the line is blocked the field does not sum the amount of this line. I have tried of everything but always I am with the problem that it indicates me that the fields are of different type. How I can do this?
Thanks.

Ian_Piddington10199

Hi Leroy

In the FlowField you need to add a table filter to your Calculation Formula. Assuming your Boolean is called blocked you would need to add

Blocked=CONST(No)

This would stop the blocked fields being included in the total. You'd also need to make sure teh Blocked field was in an appropriate key on the table you are adding up from.

regards

Ian

Leroy

Thanks for your reply. That was the problem, the bloqued field doesn't had an associated key on the table; it works now perfectly.
Many thanks for your help.