Skip to main content
K
kjain-21-Visitor
1-Visitor
June 7, 2017
Question

If there is an integer field on content level and same on document level as well and i want to summarize value of that field from all content to document level, is there any idea about this ?

  • June 7, 2017
  • 1 reply
  • 1394 views

If there is an integer field on content level and same on document level as well and i want to summarize value of that field from all content to document level, is there any idea about this ?

E.g. ABC Requirement Document (Cost)

        ABC content (Cost)

If this document has 4 content inside this having cost value 10,20,30,40 for each so cost value in ABC Requirement Document should be 100.

    1 reply

    D
    D_Thierjung1-Visitor
    1-Visitor
    June 7, 2017

    Hi Kapil Jain‌

    i would use a computed field with an aggregrate function. In this case you can't use the same field on for the segments and nodes. I would suggest to create a computed field "Aggregated Costs" for the document root with something like

    IsEmpty(aggregate("Contains",ByDocument(true,true), sum("Cost")),0)

    Please also check support document CS229357. There should be even more information that might be relevant to you.

    Regards,

    Dominik

      K
      kjain-21-VisitorAuthor
      1-Visitor
      June 7, 2017

      Thanks Dominik.

      I got to know about this after putting question here and i also got the same as you suggested also.
      Thanks a lot for your quick response.

      Regards,

      Kapil

      Terms & ConditionsAccessibility statement