Hello
I am basically using calculated fields to calculated a weighted average and my results are a little skewed because in my data source I have some empty cells in one of the columns and which i don't want to delete. is there anyway to run this calculation asking the calculated field to skip the empty cells in the data source?
i hope this is clear and if not i will upload an excel pivot table linked to a data source to help you understand my request
thank you all
If I helped, Don't forget to add to my reputation (click on the little scale)
Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
Attach a sample workbook. Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.
Remember to desensitize the data.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks