Forum Discussion
Month on Hand calculation for Q4 based on Min Inventory
Hello all, I have to calulate a column MOH calulation by Q4. Below is the screenshot of dummy data in excel attached what I am trying to achieve by using the formula. For viewing tables and and data...
Hi, Anonymous
I am not sure whether I understood your question correctly, but pleae check the data type of the column MIN Inventory #. I think it is a text type. Please try to change it to number type.
Hi, My name is Jihwan Kim.
If this post helps, then please consider accept it as the solution to help other members find it faster, and give a big thumbs up.
Linkedin: linkedin.com/in/jihwankim1975/
Twitter: twitter.com/Jihwan_JHKIM
Jihwan_Kim Yes, I did forget to change column type in my dummy report.
But I got the solution, I was confusing myself between calculation of Column and Measure. Now, got that confusion correct.
Thank You.