Forum Discussion
Calculating the Average per Row
Hello, I would like to calculate the average per row without including blank cells or 0s in my calculations. The table below gives a good example of the data I'm working on. Name Jan Feb Ma...
Hi Anonymous ,
What's the data structure of your data?
If it is like below, please check the attachment whether help.
If it is just like below, please try to UnPivot columns first. And then, refer to the attachment.
Name Jan Feb March April May A 2 0 6 B 3 6 1 2 1 C 2 3 Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
What's the data structure of your data?
If it is like below, please check the attachment whether help.
If it is just like below, please try to UnPivot columns first. And then, refer to the attachment.
Name Jan Feb March April May A 2 0 6 B 3 6 1 2 1 C 2 3
Best Regards,
Icey
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.