Joining quarter
Date & Time
FORMULA
RoundUp(3.14159, 0)
EXAMPLE EXPLANATION
Rounds 3.14159 up to the nearest whole number (with 0 decimal places), always rounding away from zero — so the result here is 4.
Joining hour of timestamp
Date & Time
FORMULA
Hour(Now())
EXAMPLE EXPLANATION
Returns the current hour, e.g. for a time-stamped log entry.
Current minute
Date & Time
FORMULA
Minute(Now())
EXAMPLE EXPLANATION
Returns the current minute component of the time.
Date value from text input
Date & Time
FORMULA
DateValue(JoiningDateInput.Text)
EXAMPLE EXPLANATION
Converts typed date text into a proper date value for JoiningDate.
Joining date formatted
Date & Time
FORMULA
Text(JoiningDate, "dd-mmm-yyyy")
EXAMPLE EXPLANATION
Formats JoiningDate as a readable string, e.g. 15-Jan-2026.
Six months before today
Date & Time
FORMULA
DateAdd(Today(), -6, Months)
EXAMPLE EXPLANATION
Calculates the date six months before today, e.g. for a review cutoff.
Second component of now
Date & Time
FORMULA
Second(Now())
EXAMPLE EXPLANATION
Returns the current second component of the time.
Day of month joined
Date & Time
FORMULA
Day(JoiningDate) <= 15
EXAMPLE EXPLANATION
Checks whether the employee joined during the first half of the month.
Total payroll
Aggregation
FORMULA
Sum(Employees, Salary)
EXAMPLE EXPLANATION
Returns the total Salary across all employee records.
Total IT payroll
Aggregation
FORMULA
Sum(Filter(Employees, Department = "IT"), Salary)
EXAMPLE EXPLANATION
Returns the total Salary of employees in the IT department.
Average salary
Aggregation
FORMULA
Average(Employees, Salary)
EXAMPLE EXPLANATION
Returns the average Salary across all employees.
Minimum salary
Aggregation
FORMULA
Min(Employees, Salary)
EXAMPLE EXPLANATION
Returns the lowest Salary value among all employees.
Maximum salary
Aggregation
FORMULA
Max(Employees, Salary)
EXAMPLE EXPLANATION
Returns the highest Salary value among all employees.
Total active employees
Aggregation
FORMULA
CountRows(Filter(Employees, IsActive = true))
EXAMPLE EXPLANATION
Returns the count of currently active employees.
Total employees
Aggregation
FORMULA
CountRows(Employees)
EXAMPLE EXPLANATION
Returns the total number of records in the Employees table.
Count IT employees earning above threshold
Aggregation
FORMULA
CountIf(Employees, Department = "IT", Salary > 50000)
EXAMPLE EXPLANATION
Returns the count of IT employees earning more than 50000.
Rounded average salary
Aggregation
FORMULA
Round(Average(Employees, Salary), 2)
EXAMPLE EXPLANATION
Calculates the average Salary and rounds it to 2 decimal places.
Salary rounded down to nearest 1000
Aggregation
FORMULA
RoundDown(Salary, -3)
EXAMPLE EXPLANATION
Rounds Salary down to the nearest thousand.
Salary modulo check
Aggregation
FORMULA
Mod(Salary, 1000) = 0
EXAMPLE EXPLANATION
Checks whether Salary is an exact multiple of 1000.
Square root of salary
Aggregation
FORMULA
Sqrt(Salary)
EXAMPLE EXPLANATION
Calculates the square root of Salary, e.g. for a statistical scaling formula.
Showing
81 –
100 of
132 formulae