Skip to main content

Hello

 

I have created a summary level formula to calculate the percantage of total records at a grouping level.  The formula I used is RowCount / PARENTGROUPVAL(RowCount, GRAND_SUMMARY).  THis woks successfully and outputs in the "Percentage of Records" field below.

 

However, I am trying to work out a percentage of the "Duration" of those records (they are Events).  So I want to get the percentage per each segment of the sum of Duration.

 

However, I cannot seem to build the correct formula for this I am presented with an error that the PARENTGROUPVAL argument type is incorrect (And when I try a different field, I simply receive the percentage of RECORDS rather than the percentage of duration.  Can anyone help point me in the right direction here?  Thanks very much!!

PARENTGROUPVAL help!!

 @Formulas - Help, Tips and Tricks

2 respuestas
  1. Eric Praud (Activ8 Solar Energies) Forum Ambassador
    25 may 2023, 15:51

    Hi,

     

    Just change your formula to:

    Duration:SUM/ PARENTGROUPVAL(Duration:SUM, GRAND_SUMMARY)

    Make sure you get the right field name for Duration by selecting it from the left hand side panel