LinkedIn
Twitter
Thank to Levent, I have been able to add my percentage total checking column to my cash-out calculation app.
However, because the formula adds up the percentages of “% Split” of rows bearing the same cash-out code and the total percentage reaches 100% after the last row of the group is entered, only the “% Split” of the last row entered of the cash-out code group will show “Correct % Split”. With others failing to update. Is there a solution to this? Refreshing does not help, I need to go click/tap the “% Split” fields of the previous rows to make the “% Check” change from wrong to correct.
The formula for “% Check” is:
IF(AND(SUM(SELECT(Monday[% Split],[Cash-Out Code]=[_THISROW].[Cash-Out Code]))<1.0002,SUM(SELECT(Monday[% Split],[Cash-Out Code]=[_THISROW].[Cash-Out Code]))>0.9998),“Correct % Split”,"! WRONG % SPLIT")
