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!!
Eric Praud (Activ8 Solar Energies) Forum Ambassador
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