Problem with a sum field

Leroy
Leroy Member Posts: 199
edited 2007-04-12 in Navision Attain
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.

Comments

  • Ian_Piddington10199
    Ian_Piddington10199 Member Posts: 167
    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
    Regards

    Ian
  • Leroy
    Leroy Member Posts: 199
    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.

Categories