Link to home
Start Free TrialLog in
Avatar of jforget1
jforget1

asked on

Fix to counter

I have a counter that tallies up the count of a bunch of fields. The formula is below, I have added a new field with is used when there are over 25 values. I need to know how I can modify this formula to add in the value from this field, "midas_over" it is a text field so it would have to be converted to number and it will just add as a single value. So if the original counter below gets to 25 and the new field has 10 over, then the final count will be 35.

list:=@Trim (midas1:.....:midas25);
n:=@Elements(list);
FIELD count_midas:=n-@Elements(@Trim(@Replace(list;"midas";"")));""
ASKER CERTIFIED SOLUTION
Avatar of Steve Knight
Steve Knight
Flag of United Kingdom of Great Britain and Northern Ireland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of jforget1
jforget1

ASKER

This is a temporary fix while I work on a multi value field attendance system using dialog boxes for entry, just can't get it quite right. Appreciate the help with the code.
I did change the field over to a number field, eliminated some of the unneeded code, thanks again.
No problem, glad to help