Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
Is there any way to do a math equation within a Pivot Table in OBI? — 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

Is there any way to do a math equation within a Pivot Table in OBI?

Received Response
2
Views
2
Comments

Summary:

Is there any way to do a math equation within a pivot table? The formula that I created is not working within the criteria tab. I'm trying to take Days Less 20 Flag / Days from Req Approval to Candidate Marked as Hired *100 to get the % of reqs that were <=20 days. The formula I have in the criteria tab to output the % is below. I broke this out into two column formulas. I've tried summarizing this in a table format with no luck, so I thought I would try a pivot table. Column F in the

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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