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(@Repl ace(list;" midas";"") ));""
list:=@Trim (midas1:.....:midas25);
n:=@Elements(list);
FIELD count_midas:=n-@Elements(@
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
I did change the field over to a number field, eliminated some of the unneeded code, thanks again.
No problem, glad to help
ASKER