Forum Discussion
Average versus average based on filter
I need to use the result of a visual matrix to calculate a new column. The data below is a simplified version of the data I have. Table A Fuel Type Gallons Gross Cost Diesel Regular ...
Thank you! This has gotten me very close. Will you look at my formula and tell me why I am getting inaccurate results?
If I remove the word SUM on line 4 it gets much closer... but still not correct.
I am sure it is something very simple that I am missing... but I have been looking at it all day and can't see what it is.
Your help is much appreciated!
did you rename the [Units] field to "Gallons" for the visual or are these different fields?
Yes, I renamed it for the visual.
no idea. Would be best if you could provide more realistic sample data