Tuesday, March 5, 2019

Calculate Total Gross Profit Percentage Based On Total Revenue per Item in a Saved Search

Navigate to Reports>Saved Searches>All Saved Searches>New

-Select Search Type = Transaction

Navigate to Criteria tab>Standard subtab>Filter column: make sure that you set a filter for Posting = is true.

To calculate for the Gross Profit percentage based by item here are the following settings that you need to have under Results tab>Columns subtab>Field column:

a. Item | Summary Type: Group

b. Formula (Percent) | Summary Type: Average | Formula: round(sum(case when {accounttype} in ('Income','Cost of Goods Sold') then nvl({grossamount},0) else 0 end)/nullif(sum(case when {accounttype} = 'Income'  then nvl({grossamount},0) else 0 end),0),4)

-Hit Save & Run button

No comments:

Post a Comment