Forum Discussion
Subtotal Report Not Working
- May 22, 2020
CMSCMSCMS Fixed it. There was something odd about the point data. It had the green triangles in the top left corner, although despite a bit of googling I couldn't find any clear information about what they signify other than an error (but this is just numbers?!). I copied the numbers to notepad, then copied them to a new spreadsheet, and now it works.
CMSCMSCMS Fixed it. There was something odd about the point data. It had the green triangles in the top left corner, although despite a bit of googling I couldn't find any clear information about what they signify other than an error (but this is just numbers?!). I copied the numbers to notepad, then copied them to a new spreadsheet, and now it works.
CMSCMSCMS Apparently green triangles can signify numbers formatted as text, although I did change the formatting to numbers 🤷:male_sign:
- SergeiBaklanMay 22, 2020Diamond Contributor
Yes, that's only an alert says the values which looks like numbers are saved as text. You may select them and from the icon drop-down menu convert to numbers