Forum Discussion
DataFormat.error We couldnt convert to Number...
That is beacuse when you made the pivot, it's necessary to create an aggregation and in that moment is when you realize your data issues, before that your data is just rows, for example, if you instead of create a pivot, create a meassure, you will see the same error.
Regards
Hi jbocachica,
I ended up finding some #N/A in my data, which was what was causing this problem.
However, this made me question something else: How come this problem only appeared whenever i unpivoted the columns? Whenever they were pivoted, i did not receive this error and could use the data perfectly.
Thanks,
Pamela
That is beacuse when you made the pivot, it's necessary to create an aggregation and in that moment is when you realize your data issues, before that your data is just rows, for example, if you instead of create a pivot, create a meassure, you will see the same error.
Regards