can someone point me how to start for this report

I would use Formula(Percent) in the results tab and then type in the data points to look from

not sure if I can do this on the search, i will probably have to try this on the report but all the financial reports I tried comes with parent/child relationship I need Scrap Expense which is child of Purchase which has account type of COGS and Total Revenue which is a child of Sales which is Account type income

If you create a transaction saved search where Account = Scrap Expense and Revenue accounts or Account Type = Income (depending on your definition of Total Revenue) and Posting = T, won't that work? Results: Case when Account = Scrap Expense then {amount} ELSE 0 END/NVL(Case when Account/Account Type = Revenue accounts or Income account type THEN {amount} ELSE 0 END),0) Summary Type: Sum Obviously, my internal IDs are wrong.