Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

Min function in formula

Posted on 2004-09-27
15
Medium Priority
?
368 Views
Last Modified: 2013-12-18
In a view formula field I have to order a text list from min to max value. I want it to be done with min function. The textlist contains 25 elements. I have tried like this

strUnique:= @unique(volume);
REM "initialize the minimum as the first of the unique volumes";
strMinVolume := @subset(strUnique;1);
REM "now take the minimum of the first and second elements of the unique volumes";
strMinVolume1 := @min(strMinVolume; @subset(@subset(strUnique;2);-1));
REM "now take the minimum of the previous minimum and the third element of the unique volumes";
strMinVolume2= @min(strMinVolume1; @subset(@subset(strUnique;3);-1));


but I am not able to proceed further. I want the ordered list to be in an array. How can I do that?

Thanks in Advance

AL
0
Comment
Question by:AboutLotus
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 7
  • 6
  • 2
15 Comments
 
LVL 19

Expert Comment

by:madheeswar
ID: 12158930
I think u r talking aboput column formula.

Instead use column Ascending sorting.
0
 

Author Comment

by:AboutLotus
ID: 12158941
Yeah it is a column formula.I tried that but the textlist doesnot gets sorted.what can I do now Madheeswar?
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12158966
Assume ur field is multi value and text.

In the column formula:

@TextTonumber(@EXplode(yourFieldname;";"))

and in the column properties:
Sorted: Ascending

And in the view properties:

Make it per row as 9


And u can show max: 9 entries in a column(I mean in a row for a doc)
0
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 

Author Comment

by:AboutLotus
ID: 12159060
I have tried that too but this works only when the multiple entries are shown as seperate entires. But I am not supposed to do that.when I tried to do without this then it is not in an ordered manner. What can I do?
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12159068
I did not got it.

U have multivalue text field. And u want to sort in Ascending. Right?

Then follow my method. And in the column properties, enable Show multivalue as separate entries(new Line).
0
 

Author Comment

by:AboutLotus
ID: 12159079
Another problem is I dont want to show this field in the view as column rather use this text list in another column formula in the same view.
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12159091
I think ur in a mixed state. U said to display the result in Ascending.

And now u want to use it in another column(U can't use the results of one Column in another column). So, ur totally in a wrong assumption or ur newbie to NOTES.

what u want to achieve ?
0
 

Author Comment

by:AboutLotus
ID: 12159093
I have tried like this I have created a coloumn which is hidden and I have sorted it in ascending and shown as multiple entries. but even If I use this sorted coulmn in another column's formula the result is assorted. ( but the constraint is the value should be sorted before used in the formula).What would be the solution?
0
 

Author Comment

by:AboutLotus
ID: 12159099
Now in a clumn formula I have to sort a field and then use it in formula., How can I do that?
0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12159107
can show some example ?

Type in a view format and tell me how u want.

Sorry, I did not understood. I don't want to take my own assumptions. I want to know exactly u want for better solution.
0
 

Author Comment

by:AboutLotus
ID: 12159132


name    marks

sre        25,37,69,83
fri         42,86,92,99


This should be the final view. The values used in marks are from a field called mk which is a text list with values as 0,20,84,35,67 and 88,76,36,89 so Now In the marks column formula I will have to sort the mk field first and then use the sorted list in the formula for display.

Is this ok?



0
 
LVL 19

Expert Comment

by:madheeswar
ID: 12159158
As per I undertood,

U want to display Marks in sorted. RIGHT? (U want it in next line or in a asme line as u shown sample?)

Below is to display in new line

Forget about another column.

U have first column as Name.

Second column: marks (Sorted in Ascending)
and in the Column formula:
@textToNumber(@Explode(mk;";"))
or try:
@textToNumber(@Explode(mk;","))

And how ur updating mk field ? I think users are entering values as text only. So, I suppose this won't be a multivalue.

And as per displaying in a single line, it is very difficult to achieve.
0
 
LVL 46

Expert Comment

by:Sjef Bosman
ID: 12159686
What's wrong with @Sort? R6 required...
0
 

Author Comment

by:AboutLotus
ID: 12178374
I am using R5.
0
 
LVL 46

Accepted Solution

by:
Sjef Bosman earned 150 total points
ID: 12178644
It cannot be done using @Formula language, there are no looping mechanisms in R5 for that purpose. My suggestion would be to use some sort of sort function in LotusScript in the PostRecalc event in the form, writing the sorted output into a new field. There are many sort-algorithms available on the Internet, so just pick one, or we can supply you one. If you need all existing documents updated, use an agent to calculate the new field.
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

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…
Sometimes clients can lose connectivity with the Lotus Notes Domino Server, but there's not always an obvious answer as to why it happens.   Read this article to follow one of the first experiences I had with Lotus Notes on a client's machine, my…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…
Want to learn how to record your desktop screen without having to use an outside camera. Click on this video and learn how to use the cool google extension called "Screencastify"! Step 1: Open a new google tab Step 2: Go to the left hand upper corn…

598 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