Solved

Fix to counter

Posted on 2006-07-24
4
198 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

For Desktop Techs: How to retain a user's Notes configuration data when swapping out the end user's computer. (Assuming that you are not upgrading to a completely different version of Notes client) All you need to do is: 1) install Notes o…
I thought it will be a good idea to make a post as it will help in case someone else faces these issues. I trust this gives an idea how each entry in Notes.ini can mean a lot for the Domino Server to be functioning properly. This article discusses t…
Windows 10 is mostly good. However the one thing that annoys me is how many clicks you have to do to dial a VPN connection. You have to go to settings from the start menu, (2 clicks), Network and Internet (1 click), Click VPN (another click) then fi…
Migrating to Microsoft Office 365 is becoming increasingly popular for organizations both large and small. If you have made the leap to Microsoft’s cloud platform, you know that you will need to create a corporate email signature for your Office 365…

863 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

Need Help in Real-Time?

Connect with top rated Experts

28 Experts available now in Live!

Get 1:1 Help Now