Let's Reconnect, thank you for making 2022 our best year yet.

Look Back
Help! Formula column behavior in column grouping — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Help! Formula column behavior in column grouping

Received Response
33
Views
11
Comments


Summary:

We have some reports where the design is best met via using Grouped columns and rows. Some grouped rows have their own formula row.

When returning data, for formula rows based on a data row, the result is correct. But a formula column based on data column that groups one or more dimensions is not correct. See screens below for clarity.

Content (required):

Grouping columns with data and formulas should return the result in a similar manner to grouped rows with data and formulas.

Version (include the version you are using, if applicable):

Screen labels from top to bottom:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!