Home
Developer Guides
Macros for HCL Unica
Macros can be used in Unica Campaign and Unica Interact to enhance your flowcharts.
Macros Reference
This section describes each available macro that is available for use in Campaign, Interact, or both. Macros are listed in alphabetical order.
COUNT macro
The COUNT macro is available only in Unica Campaign.

Developer Guides
- Validation PDK Guide
  Use the Validation Plug-in Developer's Kit (PDK) to develop custom validation logic for use in Unica Campaign.
- Macros for HCL Unica
  Macros can be used in Unica Campaign and Unica Interact to enhance your flowcharts.
  - Using Macros in Unica Campaign
    This chapter provides usage information about Unica Campaign macros. Be sure to read this chapter before you attempt to use macros in Unica Campaign.
  - Using macros in Unica Interact
    This chapter provides usage information about Unica Interact macros. Be sure to read this chapter before you attempt to use macros in Unica Interact.
  - Macros Reference
    This section describes each available macro that is available for use in Campaign, Interact, or both. Macros are listed in alphabetical order.
    - Valid Format Keywords
      The following table shows the keywords for valid formats, with a description and example of each.
    - ABS macro
      The ABS macro is available only in Unica Campaign.
    - ACOS macro
      The ACOS macro is available only in Unica Campaign.
    - ACOT macro
      The ACOT macro is available only in Unica Campaign.
    - ADD_MONTHS macro
      The ADD_MONTHS macro is available in Unica Campaign
    - AND macro
      The AND macro is available in Unica Campaign and Unica Interact.
    - ASIN macro
      The ASIN macro is available only in Unica Campaign.
    - ATAN macro
      The ATAN macro is available only in Unica Campaign.
    - AVG macro
      The AVG macro is available in Unica Campaign and Unica Interact.
    - BETWEEN macro
      The BETWEEN macro is available only in Unica Campaign.
    - BIT_AND
      The BIT_AND macro is available in Unica Campaign and Unica Interact.
    - BIT_NOT
      The BIT_NOT macro is available in Unica Campaign and Unica Interact.
    - BIT_OR
      The BIT_OR macro is available in Unica Campaign and Unica Interact.
    - BIT_XOR
      The BIT_XOR macro is available in Unica Campaign and Unica Interact.
    - CEILING macro
      The CEILING macro is available only in Unica Campaign.
    - COLUMN macro
      The COLUMN macro is available only in Unica Campaign.
    - COS macro
      The COS macro is available only in Unica Campaign.
    - COSH macro
      The COSH macro is available only in Unica Campaign.
    - COT macro
      The COT macro is available only in Unica Campaign.
    - COUNT macro
      The COUNT macro is available only in Unica Campaign.
    - CURRENT_DATE macro
      The CURRENT_DATE macro is available in Unica Campaign and Unica Interact.
    - CURRENT_DAY macro
      The CURRENT_DAY macro is available in Unica Campaign and Unica Interact.
    - CURRENT_JULIAN macro
      The CURRENT_JULIAN macro is available only in Unica Campaign.
    - CURRENT_MONTH macro
      The CURRENT_MONTH macro is available in Unica Campaign and Unica Interact.
    - CURRENT_TIME macro
      The CURRENT_TIME macro is available only in Unica Campaign.
    - CURRENT_WEEKDAY macro
      The CURRENT_WEEKDAY macro is available in Unica Campaign and Unica Interact.
    - CURRENT_YEAR macro
      The CURRENT_YEAR macro is available in Unica Campaign and Unica Interact.
    - DATE
    - DATE_FORMAT macro
      The DATE_FORMAT macro is available in Unica Campaign and Unica Interact.
    - DATE_JULIAN macro
      The DATE_JULIAN macro is available only in Unica Campaign.
    - DATE_STRING macro
      The DATE_STRING macro is available only in Unica Campaign.
    - DAY_BETWEEN macro
      The DAY_BETWEEN macro is available only in Unica Campaign.
    - DAY_FROMNOW macro
      The DAY_FROMNOW macro is available only in Unica Campaign.
    - DAY_INTERVAL macro
      The DAY_INTERVAL macro is available only in Unica Campaign.
    - DAYOF macro
      The DAYOF macro is available only in Unica Campaign.
    - DISTANCE
      The DISTANCE macro is available in Unica Campaign and Unica Interact.
    - DIV macro
      The DIV macro is available in Unica Campaign and Unica Interact.
    - EQ macro
      The EQ macro is available in Unica Campaign and Unica Interact.
    - EXP macro
      The EXP macro is available only in Unica Campaign.
    - EXTERNALCALLOUT macro
      The EXTERNALCALLOUT macro is available only in Unica Interact.
    - FACTORIAL macro
      The FACTORIAL macro is available only in Unica Campaign.
    - FLOOR macro
      The FLOOR macro is available only in Unica Campaign.
    - FORMAT macro
      The FORMAT macro is available only in Unica Campaign.
    - FRACTION macro
      The FRACTION macro is available only in Unica Campaign.
    - GE macro
      The GE macro is available in Unica Campaign and Unica Interact.
    - GET macro
      The GET macro is available in Unica Interact.
    - GROUPBY macro
      The GROUPBY macro is available only in Unica Campaign.
    - GROUPBY_WHERE macro
      The GROUPBY_WHERE macro is available only in Unica Campaign.
    - GT macro
      The GT macro is available in Unica Campaign and Unica Interact.
    - IF macro
      The IF macro is available in Unica Campaign and Unica Interact.
    - IN macro
      The IN macro is available in Unica Campaign and Unica Interact.
    - INT macro
      The INT macro is available only in Unica Campaign.
    - INVERSE macro
      The INVERSE macro is available only in Unica Campaign.
    - IS macro
      The IS macro is available in Unica Campaign and Unica Interact.
    - ISERROR macro
      The ISERROR macro is available only in Unica Campaign.
    - ISODD macro
      The ISODD macro is available only in Unica Campaign.
    - ISEVEN macro
      The ISEVEN macro is available only in Unica Campaign.
    - ISODD macro
      The ISODD macro is available only in Unica Campaign.
    - LE macro
      The LE macro is available in Unica Campaign and Unica Interact.
    - LIKE macro
      The LIKE macro is available in Unica Campaign and Unica Interact.
    - LN or LOG macro
      The LN or LOG macro is available only in Unica Campaign.
    - LOG2 macro
      The LOG2 macro is available only in Unica Campaign.
    - LOG10 macro
      The LOG10 macro is available only in Unica Campaign.
    - LOWER macro
      The LOWER macro is available in Unica Campaign and Unica Interact.
    - LT macro
      The LT macro is available in Unica Campaign and Unica Interact.
    - LTRIM macro
      The LTRIM macro is available in Unica Campaign and Unica Interact.
    - MAX macro
      The MAX macro is available in Unica Campaign and Unica Interact.
    - MEAN macro
      The MEAN macro is available in Unica Campaign and Unica Interact.
    - MIN macro
      The MIN macro is available in Unica Campaign and Unica Interact.
    - MINUS
      The MINUS macro is available in Unica Campaign and Unica Interact.
    - MOD macro
      The MOD macro is available in Unica Campaign and Unica Interact.
    - MONTHOF macro
      The MONTHOF macro is available only in Unica Campaign.
    - MULT macro
      The MULT macro is available in Unica Campaign and Unica Interact.
    - NE macro
      The NE macro is available in Unica Campaign and Unica Interact.
    - NOT macro
      The NOT macro is available in Unica Campaign and Unica Interact.
    - NUMBER macro
      The NUMBER macro is available in Unica Campaign and Unica Interact.
    - OR
      The OR macro is available in Unica Campaign and Unica Interact.
    - POSITION macro
      The POSITION macro is available only in Unica Campaign.
    - PLUS macro
      The PLUS macro is available in Unica Campaign and Unica Interact.
    - POW
      The POWER macro is available in Unica Campaign and Unica Interact.
    - RANDOM macro
      The RANDOM macro is available only in Unica Campaign.
    - RANDOM_GAUSS macro
      The RANDOM_GAUSS macro is available only in Unica Campaign.
    - ROUND macro
      The ROUND macro is available only in Unica Campaign.
    - ROWNUM macro
      The ROWNUM macro is available only in Unica Campaign.
    - RTRIM macro
      The RTRIM macro is available in Unica Campaign and Unica Interact.
    - SIGN macro
      The SIGN macro is available only in Unica Campaign.
    - SIN macro
      The SIN macro is available only in Unica Campaign.
    - SINH macro
      The SINH macro is available only in Unica Campaign.
    - SIZE macro
      The SIZE macro is available in Unica Interact.
    - SORT macro
      The SORT macro is available in Unica Interact.
    - SQRT macro
      The SQRT macro is available only in Unica Campaign.
    - STDV or STDEV macro
      The STDV or STDEV macro is available in Unica Campaign and Unica Interact.
    - STRING_CONCAT macro
      The STRING_CONCAT macro is available in Unica Campaign and Unica Interact.
    - STRING_HEAD macro
      The STRING_HEAD macro is available only in Unica Campaign.
    - STRING_LENGTH macro
      The STRING_LENGTH macro is available only in Unica Campaign.
    - STRING_PROPER macro
      The STRING_PROPER macro is available only in Unica Campaign.
    - STRING_SEG macro
      The STRING_SEG macro is available only in Unica Campaign.
    - STRING_TAIL macro
      The STRING_TAIL macro is available only in Unica Campaign.
    - SUBSTR or SUBSTRING macro
      The SUBSTR or SUBSTRING macro is available in Unica Campaign and Unica Interact.
    - SUM macro
      The SUM macro is available in Unica Campaign and Unica Interact.
    - TAN macro
      The TAN macro is available only in Unica Campaign.
    - TANH macro
      The TANH macro is available only in Unica Campaign.
    - TOTAL macro
      The TOTAL macro is available in Unica Campaign and Unica Interact.
    - TRUNCATE macro
      The TRUNCATE macro is available only in Unica Campaign.
    - UPPER macro
      The UPPER macro is available in Unica Campaign and Unica Interact.
    - VARIANCE macro
      The VARIANCE macro is available only in Unica Campaign.
    - WEEKDAY macro
      The WEEKDAY macro is available only in Unica Campaign.
    - WEEKDAYOF macro
      The WEEKDAYOF macro is available only in Unica Campaign.
    - XOR
      The XOR macro is available in Unica Campaign and Unica Interact.
    - YEAROF macro
      The YEAROF macro is available only in Unica Campaign.

COUNT macro

The COUNT macro is available only in Unica Campaign.

Syntax

COUNT(data)

Parameters

data

The cell range to count the number of cells in. This can be a constant value, a column, a cell range, or an expression evaluating to any of the above. For the format definition of data, see the "Macro Function Parameters" section in the chapter in this guide for your product.

Description

COUNT counts the number of values in the specified data range. It returns a new column containing a single value representing the number of cells containing values within the specified data range.

Note: Counting a blank column returns zero.

Examples


`TEMP = COUNT(AVG(V1:V5))` Creates a new column named `TEMP` containing a single value of one (the function `AVG` returns a single cell in the default mode).
`TEMP = COUNT(V1)` Creates a new column named `TEMP` containing a single value indicating the number of cells containing values in column `V1`.
`TEMP = COUNT(V1:V3)` Creates a new column named `TEMP` containing a single value indicating the number of cells containing values in columns `V1`, `V2`, and `V3`.
`TEMP = COUNT(V1[10:20])` Creates a new column named `TEMP` containing the value `11` (ranges are inclusive), given that the cells all contain values.
`TEMP = COUNT(V1[1:5]:V4)` Creates a new column named `TEMP` containing the value `20` (5 cells in each column times 4 columns = 20 cells), given that all the cells contain values.
`TEMP = COUNT(V1[1:10])` Creates a new column named `TEMP` containing the value `3`, given that rows 1-3 of column `V1` contain values and rows 4-10 are empty.

Related functions


Function	Description
`SUM` or `TOTAL`	Computes the sum of a range of cells

Have feedback?
Google Analytics is used to store comments and ratings. To provide a comment or rating for a topic, click Accept All Cookies or Allow All in Cookie Preferences in the footer of this page.