What's new in Customer Journeys?

Connect and learn more!
OBI Report Query. Formula — 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

OBI Report Query. Formula

Accepted answer
48
Views
2
Comments

Summary:

Hi All, I am having trouble getting a formula working.

Background: we have two related numeric flex fields.

Requisition Flex Field - FTE Requested

Submission Job Offer Flex Field - FTE Offered

What I need to do is get all the FTE Requested from requisitions, and Subtract All the FTE offered

This works on a line by line (requisition by requisition) status, but not once I try to total rows.

These negative amount are perplexing me.

However, at the individual req level, this works


My Formula

FTE Requested: (Cast("Requisition Flex Fields"."UDF15" as double))

FTE Offered: Sum(Cast("Submission Job Offer Flex Fields"."UDF8" as double))

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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