Now I make my leave app.
which this leave app Those on leave must enter the number of leave days themselves. As for the remaining leave days, I have a formula that automatically breaks.
But on the issue of those taking leave from work, sometimes they enter the wrong number. If I make an option Can the formula calculate this?
The total leave fields will be filled in by the leave recipient themselves. But I'll make it an option. But the formula doesn't automatically break.
Formula used for automatic subtraction
ANY(SELECT(The right to leave work[เธชเธดเธเธเธดเนเธเธฑเธเธฃเนเธญเธ], ([_THISROW].[Employee ID] = [Employee ID])))
- SUM(
SELECT(
Employee leave work[เธฃเธงเธกเธงเธฑเธเธฅเธฒ],
AND(
([เธเธฃเธฐเนเธ เธ ] = ("เธเธฑเธเธฃเนเธญเธ")),
[Employee ID] = [_THISROW].[Employee ID]
)
)
)
User | Count |
---|---|
41 | |
31 | |
31 | |
16 | |
14 |