Leave app Using options and automatic deduction formula

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?

0 2 110
2 REPLIES 2

numfon_naka_0-1701071928517.png

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]

)
)
)

Top Labels in this Space