Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
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

How to group the values using different columns in OTBI report

edited Apr 29, 2024 12:04PM in Reporting & Analytics for Fusion Service 1 comment

I want to create spearate column in the OTBI to get number of invoice count using supplier name, Invoice number and invoice creation date columns.

I could be able to create a custom formula to get invoice count based on the supplier name vise using below formula

COUNT(DISTINCT "- General Information"."Invoice Number" BY "Supplier"."Supplier Name")

Have any method to add one or more columns for above "COUNT(DISTINCT" formula to get required result ?

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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