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

seeing error in custom formula

Received Response
43
Views
8
Comments
edited Apr 1, 2021 5:37PM in Narrative Reporting 8 comments

Content

Hi...I'm creating a report where one of my  data columns has an account that is dynamic calc (sales per sq ft).  Then I have a total line that sums the values from above.  The sales per sq ft account is also summing, which doesn't make sense, so I created a custom formula in the cell for the total to manually calculate divide sales/sq ft.  I also have this line grouped by one of the dimensions in the row (brand).  The first brand, the calc works fine.  But the second brand it errors out and the last brand is calculated incorrectly. 

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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