Newbie Questions

Re: Formula Syntax Help

Ian Dawson — Thu, 05 Mar 2009 01:18:41 GMT

Hi JC,

Floor to seems to be a bit like a truncate function in EXCEL. It returns the largest integer below the value you enter.

So that for floor(34.765) = 34.

And the same applies to a variable, or formula like the age formula below.
When the program is run it will return the next integer value below.

Only one argument can be inserted.

floor((number(substring(today(), 1, 4)) +
            number(substring(today(), 6, 2)) / 12 +
            number(substring(today(), 9, 2)) / 365.25) -
          (number(substring(@emplye_dob, 1, 4)) +
            number(substring(@emplye_dob, 6, 2)) / 12 +
            number(substring(@emplye_dob, 9, 2)) / 365.25))

Re: Formula Syntax Help

Jimmy — Thu, 05 Mar 2009 01:04:53 GMT

You cannot use floor() with multiple fields, nor would it make sense to. floor() rounds down a single numerical value.

What you seem to need is the max() function. However, the max() function only accepts one XPath argument, so you have essentially two options:

Put the numerical field in a repeating group and reference it by its path:

So if I have a data source like this:

myFields
   group1
       group2 (repeating)
            valueNode

I would use the formula xdMath:Max(/my:myFields/my:group1/my:group2/my:valueNode)

Arrange the data source so the value fields all have the same name, and use a more general XPath expression:

So if the data source is like this:

myFields
   group1
      valueNode
   group2
      valueNode
   group3
      valueNode

I could use the formula xdMath:Max(/my:myFields//my:valueNode)

Formula Syntax Help

SPS Cortez — Wed, 04 Mar 2009 20:28:02 GMT

Newbie Question: Can anyone out there post an example of the proper syntax to use when using the "floor" function against multiple fields? I need to determine the highest value form multiple fields, but I haven't figured out the proper syntax.

Example:

Field A = 4

Field B = 2

Field C = 5

floor(((Field A),(FieldB),(Field C)))

Thanks,