Friday, November 16, 2018

Use of Effective Rate field with Summary Type = Average in the Results tab of the saved search generates an unexpected error.

Workaround:Use Formula (Currency) field. 

See steps below:

1.     Edit the Resultstab of the search.

2.     Highlight the Effective Rate field then hit Remove.

3.     Add the Formula (Currency) field below:

        ·        Field: Formula (Currency)

        ·        Summary Type: Average

        ·        Function: Round to Hundredths

        ·        Formula: {effectiverate}

        ·        Custom Label: Effective Rate (Average)

4.     Hit Done.

5.  Click Preview/Save.

No comments:

Post a Comment