I have a table that I used to create a pivot.
All items are pulling through except for the budget data which is only showing "count" when I set the value to sum, it shows $0
I have a table that I used to create a pivot.
All items are pulling through except for the budget data which is only showing "count" when I set the value to sum, it shows $0
Your budget data is text - you can tell because you can see the $ signs in the formula bar when you select one of the cells. If you replace those with nothing using the Find/Replace dialog, it will convert them to numbers, then you just refresh the pivot.
Actually, not quite that simple, you have some other odd characters at the end of the numbers. I've cleaned them up in this version.
Last edited by rorya; 05-24-2022 at 11:11 AM.
Rory
Your budget values on Sheet1 are text, not numbers. How did you get this data into your Excel file? You have invisible characters, $, and "," in there that have to be removed.
EDIT: A day late and a dollar short.
Jeff
| | |·| |·| |·| |·| | |:| | |·| |·|
Read the rules
Use code tags to [code]enclose your code![/code]
Man, I appreciate you guys...I had converted it from text to currency, but didn't know about anything invisible in it....thank you!
Converting the cell format from Text to Currency does not change what is actually in the cell. Even though you changed the format, the data was still text.
If your question has been answered please mark your thread as "Solved" so that members will know by looking at the thread title that your problem is solved. Go to the menu immediately above your first post to the thread and click on Thread Tools. From the dropdown menu select "Mark this thread as solved..."
If a member helped you solve your problem, consider adding to their reputation by clicking addreputationiconsmall.jpg below their name.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks