Solved

Fix to counter

Posted on 2006-07-24
4
202 Views
Last Modified: 2013-12-18
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";"")));""
0
Comment
Question by:jforget1
  • 2
  • 2
4 Comments
 
LVL 43

Accepted Solution

by:
Steve Knight earned 500 total points
ID: 17169065

Sounds kinda odd but you know your app :-)  Any reason why the other field is text for instance?

list:=@Trim (midas1:.....:midas25);
n:=@Elements(list);
over:=@If(midas_over!="" & @IsNumber(midas_over);@TextToNumber(midas_over);0);
FIELD count_midas:=over+(n-@Elements(@Trim(@Replace(list;"midas";""))));

""
0
 

Author Comment

by:jforget1
ID: 17175378
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.
0
 

Author Comment

by:jforget1
ID: 17175512
I did change the field over to a number field, eliminated some of the unneeded code, thanks again.
0
 
LVL 43

Expert Comment

by:Steve Knight
ID: 17175590
No problem, glad to help
0

Featured Post

Active Directory Webinar

We all know we need to protect and secure our privileges, but where to start? Join Experts Exchange and ManageEngine on Tuesday, April 11, 2017 10:00 AM PDT to learn how to track and secure privileged users in Active Directory.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

  In today’s Arena we can’t imagine our lives without Internet as we are highly used to of it. If we consider our life style just for only 2 min we found that face to face communication is swapped by e-communication.  Every Where from Works place to…
IBM Notes offer Encryption feature using which the user can secure its NSF emails or entire database easily. In this section we will discuss about the process to Encrypt Incoming and Outgoing Mails in depth.
Nobody understands Phishing better than an anti-spam company. That’s why we are providing Phishing Awareness Training to our customers. According to a report by Verizon, only 3% of targeted users report malicious emails to management. With compan…

828 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question