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")
You are probably using normal column, correct?
Yes. Is there any special types of columns for this kind of formulas?
Hi Steve, so virtual columns will update real time when data change?
Virtual columns update in real time within a form view, and outside a form view when the app syncs. Non-virtual (i.e., normal) columns only update when the row itself is updated. Note, however, that virtual column values are not recorded in your spreadsheet.
User | Count |
---|---|
41 | |
36 | |
28 | |
23 | |
16 |