Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

Is it possible to use the calculated aggregate function within a custom column?

Avatar

Level 10

Hi WF Community,

Does anyone know if it's possible to create a calculated aggregate using a custom column within a report view, or can you only use the aggregate function (text mode) on standard fields when creating a custom column in a report?

For example, I have a custom calculated column in an Hours report that does the following:

  • Custom Field A (Target Client Billable %) multiplied by 40 (hrs per week) = X
  • Sum hours for user A divided by X (result of above calc) = Y

I want to aggregate this calculated custom column up to the grouping level so I can see a value by the hour Owner grouping. See attached screenshot of what I have right now (no aggregate)

Here is my text mode code that isn't aggregating:

aggregator.valueexpression=({hours}/({owner}.{DE:Target Client Billable %}*40)

aggregator.valueformat=compound

displayformat=doubleAsPercentRounded

displayname=% of Goal Client Billable

textmode=true

valueexpression=CONCAT({hours}/({owner}.{DE:Target Client Billable %}*40),"%")

valueformat=Int

Thanks.

Nick

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

2 Replies

Avatar

Level 10

Hi - for custom columns (things that use valueexpression) you aren't able to aggregate as the data isn't stored in the database anymore.

However, you can do it if you use calculated fields. Are you using an object type that can have a custom form?

Avatar

Level 10

Thanks, Anthony. And that's too bad.

Nope, it's on the Hours object that I would need to add the custom calculated field.