Explore Categories

 

 PDF

Functions and Actions

$$IsRepeatColumnContext

The function IsRepeatColumnContext validates whether the report is in columnar mode or not. 

Syntax

$$IsRepeatColumnContext

Example

[Report: FLT Range Value]

Set : ReportFilterObjType: If $$NumSets = 1 Then @@FLTSingleSetObj Else If NOT $$IsRepeatColumnContext Then $$GetFilterObjType:@@RangeFilter Else $$GetFilterObjType:@@ValueFilter

$$ExtractPatternEx

The function returns the extracted values provided at the input string. The return value retains space, comma, and hyphen depending on the parameters passed.

Syntax

$$ExtractPatternEx:<Expression>:<Pattern Expression>:<Logical value 1>:<Logical value 2>:<Logical value 3>

Where,

  • Expression can be any string value that needs to be extracted.
  • Pattern expression can be any pattern the required string needs to be extracted.
  • Logical value 1 to retain spaces. This is an optional parameter. In absence of the value the default value is set to No.
  • Logical value 2 to retain comma. This is an optional parameter. In absence of the value the default value is set to No.
  • Logical value 3 to retain hyphen. This is an optional parameter. In absence of the value the default value is set to No.

Example

[Field: Fld 1]

Set as : $$ExtractPatternEx:”ab-c def,12-3 45,Z”:”a-c,1-3,Z”:Yes:Yes:Yes

Output

ab-c ,12-3 ,Z

$$RemoveChar

The function allows to remove characters with an option to do removing in the leading, at the trailing or when surrounded by other characters and return the trimmed string

Syntax

$$RemoveChar:<Expression 1>:<Expression 2>[:<Logical value 1>[:<Logical value 1>[:Logical value 1>]]]

Where,

  • Expression 1 can be any string that need to extracted
  • Expression 2 can be any character that needs to removed from the above string
  • Logical Value 1 is to remove characters from the leading. In absence of the value the default value is set to Yes.
  • Logical Value 2 is to remove characters from the enclosed. In absence of the value the default value is set to Yes.
  • Logical Value 3 is to remove characters from the trailing. In absence of the value the default value is set to Yes.

Example

[Field: Remove Char] Use           : Name Field
Set As        : $$RemoveChar:@@StringToBeTrimmed:@@CharToBeRemoved:@@RemoveLeading:+

                 @@RemoveEnclosed:@@RemoveTrailing
Set Always    : Yes
Read Only     : Yes

[System: Formulae]

StringToBeTrimmed  : ”  29AAA CP7879 D1Z0  “

CharToBeRemoved    :”  “

RemoveLeading      : Yes

RemoveEnclosed     : Yes

RemoveTrailing     : Yes

$$CmpNumberFromPath

The function returns the company based on path specified as parameter. 

Syntax

$$CmpNumberFromPath:<Expression>

Where,

  • <Expression> can be any string that is directory path which has data.

Example

[Field: CompanyNumber]

Set as     : $$CmpNumberFromPath:##SVCurrentPath

$$IsValidCompanyDir

The function determines whether the given path is of a company. 

Syntax

$$IsValidCompanyDir:<Expression>

Where,

  • <Expression> can be any string that is directory path which has data.

Example

[Field : CmpValidPath] 

Set as :  If  $$IsValidCompanyDir:##SVCurrentPath then ##SVCurrentPath else “”

$$ColumnNumber

This function returns the column number in a columnar report. If it is not a columnar report it will return zero.

Syntax

 $$ColumnNumber

Example

[System: Formula]

    IsFilterNAInColumn : $$ColumnNumber > 0 AND @@FLTIsRemoteCompany

Action – CopyToClipboard

The action would take input expression that evaluates to a string which needs to be copied to the clipboard and perform the copying.

Syntax

CopyToClipboard:<StringToBeCopied>

Example

[Key: CopyToClipBoard]

Key     : Ctrl + C
Title   : $$LocaleString:”Copy”
Action  : Copy To Clipboard : ##InputToClipBoard

TallyHelpwhatsAppbanner
Is this information useful?
YesNo
Helpful?
/* */