This topic contains 2 replies, has 0 voices, and was last updated by kennethm 7 years, 5 months ago.
-
Posts
-
anton8359- Contributions: 0
- Level 1
- ☆
Is there a way for the Est. Gross Profit Percent to show the Percentage of the Total Profit / Total Sell rather then the sum of all the Gross Profit Percentages in the Total line ??? So it shows a total margin that’s accurate rather then a sum of margins
Attached Files
This is a cached copy. Click here to see the original post. -
torin@aminian.com- Contributions: 0
- Level 1
- ☆
It looks like I was able to get that but it may have to be on a separate search as it seems to work only when there is one row on the results. Not sure if that will work for your purposes but you can take a look. Here’s the setup:
Field: Formula (percent)
Summary Type: Average
Formula: SUM({tranestgrossprofit})/NULLIF(SUM({amount}),0)
-
kennethm- Contributions: 0
- Level 1
- ☆
I did something similar to torin for a customer:
Field: Formula (percent)
Summary Type: Maximum
Formula: SUM({estgrossprofit})/NULLIF(SUM({amount}),0)
This was so that the customer could get a Gross Profit Percent per class or location on a saved search so they grouped the saved search by the classification.
You must be logged in to reply to this topic.