Hello,
I am not sure what is wrong here:
Solved! Go to Solution.
Hello @aashca9
Let me try to help you here. What is the error you are getting?
In theory, this formula should get you the correct answer but it has 2 unnecessary elements;
In any case, the above won't cause the formula to give errors or produce the wrong values necessary. So back to my first question... what is the error you are getting?
@aashca9 your formula seems correct , just one suggestion as per best practice while using IF else , use condition which will have an early exit i.e which will check the If condition less no of times, you see only 1 week is 1st week of Timescale rest all are as per the boolean, so if you use if not sys time.not 1st week then beginning inventory else previous ending inventory, it is more efficient as per best practice
Thank you for all the responses. I was able to figure it out.
Hello,
The formula is giving me these values. Please find the attached. Any help is greatly appreciated.
Thank you
Not sure why but I am also getting same values.
Thank you Mukul, I know where I went wrong. I got the correct values now.
Jaya