Forum Discussion
Weeks on Hand Calculation
Hello everyone!! I am trying to create an equation for determing Weeks on Hand that mimics the one we currently use in Excel. Here is the current excel formula: =IF(ISERROR(IF(K362<SUM(L348...
Thank you for the above. I was confused how others could upload a file but I couldnt. I have attached link to google drive that has excel and PBIX files.
Excel:
https://drive.google.com/file/d/1Rcj_T42Wid1lyk3f3_sWS0eMC14LVxXx/view?usp=sharing
PBIX:
https://drive.google.com/file/d/16zTm9_GLF2vGvzgzMV6vAlOFRoP6dh1v/view?usp=sharing
If you cant access my files above let me know.