HCL Domino - Examples: @Abs - Need a Domino Consultant? Call NotesMail +1 212-599-2048

HCLSoftware Business Partner Domino Consulting Services CRUCIAL Notes Tools +1 212-599-2048	Domino Consulting Services CRUCIAL Notes Tools Domino administration Notes development	Chat now
.

Need a Domino Consultant? Call NotesMail +1 212-599-2048 - HCLSoftware Business Partner

FORMULA LANGUAGE

Examples: @Abs
1. This example returns 2.16.

@Abs(2.16)

2. This example returns 2.15 and 2.16 in a list.

@Abs(2.15 : (2.16))

3. This example returns 2.16 if the number in the field named Net is either 2.16 or 2.16.

@Abs(Net)

4. This example returns 25 if Score1 = 50 and Score2 = 75, or if Score1 = 75 and Score2 = 50.

@Abs(Score1 - Score2)

5. This formula, for a computed number field called numDays, uses @Abs to calculate the number of days between two dates, which are stored in time fields dateA and dateB. @Integer(dateA-dateB) returns the number of seconds between dateA and dateB, so the formula divides by 60*60*24 to get days. For example, if dateA is 08/11/95 and dateB is 09/22/95, the formula returns: 42.

@If( numDays = ""; 0; @Abs( @Integer( dateA - dateB ) / (60 * 60 * 24 ) ) )

See Also

@Abs

Feedback on Help or Product Usability?

Help on Help

All Help Contents

Feedback on Help or Usability?

Help on Help

All Help Contents