LinkBack URL
About LinkBacks
OK...I understand.
Try this regular formula, copied down:
and use this formula for your total:
H4: =IF(I4,$E$4*J4,($E$4-SUM(I$4:I$27))*(J4/SUMIF(I$4:I$27,"",J$4:J$27)))
Does that help?H28: =SUMIF(I4:I27,"",H4:H27)+SUM(I4:I27)
OK...I understand.
Try this regular formula, copied down:
and use this formula for your total:H4: =IF(I4,$E$4*J4,($E$4-SUM(I$4:I$27))*(J4/SUMIF(I$4:I$27,"",J$4:J$27)))
Does that help?H28: =SUMIF(I4:I27,"",H4:H27)+SUM(I4:I27)
It gets me very close.
I'm not sure if it's possible to have the next hours planned goal, as it adjusts, not revert back to the original planned goal once the current hour has been updated with an actual.
So for instance, instead of {=I4,$E$4*J4} as the constant goal it reverts to, having it actually stay what the updated goal changed to.
I think it's time for you to post and example that demonstrates what you want to see.
I uploaded an edited sheet laid out with how it works presently with the formula and how I'd like the formula to eventually work.
The second table has the formulas knocked out of the planned goal that has actual units next to it.
Hopefully it clears things up!
Planned Vs Actual.xlsx
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks