Page tree

Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.
Comment: Published by Scroll Versions from space DEV and version next

...

You can use basic comparison operators to perform comparisons on your data. In this example, the compareCol column is generated as the evaluation of 3 < 6, which is true:

d-

...

showNotetrue

...

trans
p03Value'compareCol'
Typestep
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02Value(3 < 6)

...

p03NameNew column name
SearchTermNew formula

For more information, see Comparison Operators.

...

Boolean values can be true or false, so comparisons like the following can be applied to a Boolean set of values:

d-

...

trans
Typestep
p01NameColumns
p01ValueAttendance
p02NameFormula
p02ValueIF(isSeated == true,true,Attendance)
SearchTermEdit column with formula

In the above case, the value in Attendance is set to true if the value in the isSeated column is true. Otherwise, the current value in Attendance is used. 

...

Info

NOTE: Both parameters of the DATEDIF function must be column references containing valid date values.

d-

...

trans
p03Value'DurationInDays'
Typestep
p01NameFormula type
p01ValueSingle row formula
p02NameFormula
p02ValueDATEDIF(startCol, endCol, 'day')

...

p03NameNew column name
SearchTermNew formula

See DATEDIF Function.

Compare String Values

...