[anton8359]

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]

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]

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.

[Author]

Posts