Collect record for previous day to Calculate variance
Main problem: I am attempting to collect the record of Daily absent for the previous day, I get incorrect argument error. I could use any help.
My end goal is to use the previous day record against the daily absent record to get the variance in numbers and percentage. I would appreciate any other intuitive way of doing that, if there is any.
Help Article Resources
Check out the Formula Handbook template!