This discussion has been locked.
You can no longer post new replies to this discussion. If you have a question you can start a new discussion

Calculate Expression does not work when the third value is missing

Hello everyone,

we have an object with a class called construction project, for this there is as property the totals from the individual invoices which are categorized. In this categorization there is then a sum as an example we have a category "Sum Material", here the sum of all invoices is displayed with this category, the same we have for "Sum Fuel" & "Sum Subcontractor". Problem is now that the "Total sum" so the sum from all categories together is displayed only when all 3 categories are filled, how do I set the invoice in the Property Calculator so that a sum comes about even with only two filled categories.

Parents Reply
  • Either might work, at least if these objects are always created in the client and not via the API since metadata card configurations are only applied when the metadata card is displayed to the user. You could test SetValue in MDCC first since it's probably easier to set up.

Children
  • The problem is that the calculation does not allow any value, the values are extracted from the linked calculations and then added together for each category and a new construction project I cannot create, because these are linked to a database.

  • You'll need to find some way to make sure there's a value for all the properties that Property Calculator uses in the operation. One option would be to use three helper properties that you can set yourself. I.e. copy the calculated values to helper properties and if the value is empty, set it as 0. Then use these helper properties in your Property Calculator sum operation.