1. Home
  2. Knowledge Base
  3. General Shibumi Knowledge
  4. Solution Design
  5. Business Logic
  6. Expressions
  7. Functions
  8. minif()
Searching...

minif()

Contents

The minif() function returns the minimum value from a comparison of the value across all instances of a specified template. The instances must be descendants (e.g., children, grandchildren, etc.) or an association of the current work item to be included in the aggregation.

Syntax

minif(template API name, value, condition)

Argument Description
template API name / association name

(required)

 The template API name OR and association of the template instances containing the value to be compared.
value

(required)

 The value for which to do the minimum comparison.

The value arguments can be constants (i.e., hard-coded values or attribute references) and/or references to metrics. The value argument can also be a mathematical equation.
condition

(optional)

 The filter that determines which values to be included in the comparison.

Notes

  • The filter can include “and” and “or” to further clarify the result set to include.
  • The “active=true” or “active=false” filter can be used to restrict the result set to specifically Active or specifically Inactive work items.  Not including this filter will retrieve all instances.
  • An abbreviation for “active=true” is simply “active”

Where Available

  • Metric expression
  • Attribute expression

Examples

Where Example(s)
Metric expression

 

 

 minif(Initiative__t, OPEX__m)

minif(Initiative__t, OPEX__m, active=true and business_unit__c = "West")

minif(Initiative__t, (OPEX__m + CAPEX__m) * currency_conversion__c, active=true and business_unit__c = "West")
Attribute expression
 minif(Initiative__t, Due_Date__c)

minif(Initiative__t, Due_Date__c, Priority_Level__c=”High”)

 

Updated on February 7, 2023
Tagged:

Related Articles