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

Drill Down from the Master to Detail via Action Link using case formula column

Received Response
21
Views
3
Comments
edited Jul 14, 2020 9:06AM in Reporting and Analytics for ERP 3 comments

Summary

I am trying to drill from the Master report to the detail report, I am fetching the count of rejected invoices with respect to each status

Content

Dear Friends,

My Requirement is to fetch the master Details Report. I am able to acheive it via Action Link but when I am trying to fetch via case formula field it is not working as aniticipated.

My Master Report displays the count of all the invoices w.r.t the Approval status.

My Approval status column is derived with the below formula field.

CASE WHEN "Payables Invoices - Transactions Real Time"."- Invoice Approval Information"."Approval Status"='Rejected' AND

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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