PROPERTY CALCULATOR

I noticed a cool new function PROPERTY CALCULATOR. I would like to test if using this new function it would be possible to make a sum of hours worked on for example a service ticket or a business case. We have some class, e.g. a business case, where the hours worked are recorded, see fig:  

Thanks advance!

Does anyone have experience with this?

- pehol

  • I think it would be possible if each of those "Hours worked" objects was distinct. Say; each object has three phases. Phase one took 6 hours, phase two 7, phase three 5.

    But if it's a list of variable length of "hours worked" objects I know of no way.

  • thank you for your insights.

    There is a binding between "business case" and "hours worked" objects, i.e. we know which and how many "hours worked" objects are bound to "business case". It is now "just" a matter of how to technically add up the "Hours" values. I think.

  • Look at pages 40 & 41 of the Property Calculator manual.. I would collect all "hours worked" objects in a managed property (Compliance Kit) on "business case" object and do the calculation like stated in "10.2.6 Reporting" on page 40..


    https://kb.cloudvault.m-files.com/#/vault/{3ECA226F-7B54-428B-B539-DE443E6134EC}/objects/66E9E4F1-014D-4EFC-966F-30C574B04B65/latest

  • Thank you very much for your help, however why should I use managed property? Can you please be more detailed?

    - pehol

  • To have a property on the host Object which collects all the hours worked objects.. I assumed you linked from the hours worked objects to the business case Object.. Managed property basically creates a backlink..

  • I have used same combo as well. It works in specific use cases but there is one drawback. If someone change number of hours in "hours worked" object, the sum will not get updated. CK does not trigger calculation, because list of "hours worked" objects is not changed.

    Instead of CK, PC's "Update related objects" rule can trigger the calculation when either Business case or hours is modified. But taking that into use, I would recommend not to use Managed properties with that. (They would both try to update same objects which lead sometimes weird conflicts.)

    My suggestion is to use following PC configurations:

    • For Business Case:
      • Search objects -rule to collect list of "hours worked".
      • Calculate expression -rule to count sum of hours
      • (After calculation, "Hours worked" list can be removed with "Remove Property" - mode if you do not want to leave it visible on metadata)
    • For Hours worked:
      • Update related objects rule to update Business case if Business case or hours is modified.
        • You probably want to set "Update objects behind removed lookups" and "Update immediately" flags on in configs.
  • I thought Managed Properties would trigger the Update of the Host Object, when modifying the Related Objects, maybe I'm wrong..

    But as alternative I would it do like you suggested, this should be also the way described in the Manual on Page 40/41..

  • as wrote  , can we use this configurations for calculate a modified hours?

    Could me also glue, how to use the rules - Search objects with calculate hours?

    Many thanks for your support.

    - pehol

  • Would you be so kind, could you please give some hints regardings your suggestions? I have no idea, how to search object rule....and also other rules.

    Or is there some detailed described this functions? I have found a manual but it seems this functions are missing there.

    Thanks in advance.

    - pehol