Skip to main content

GPXD Formula

The GPXD formula displays detailed results of a business view in the spreadsheet.

See Business View Formulas to learn how to access the GPXD panel.

  1. Use the following table to enter or modify data in the GPXD panel.
    2. Field Description

    Name

    Select the required business view. Business views are available based on user permissions.

    • Use the drop-down menu to select the business view.

    • Click Browse to open the Select Business View panel which retrieves a list of all the business views from Angles within Excel.

      • Search by text.

      • Search by tags. Select the checkbox against the tag(s) in the drop-down menu and click Apply to filter the list.

      • Click Expand All to view all business view descriptions or click the expand icon against individual business views.

      • Select the radio button to use that business view.

    • Click the refresh button to load any newly added or assigned business views.

    Sheet

    Select the worksheet destination for the formula. Defaults to the current active worksheet.

    Starting Cell

    Enter the starting cell for the template.

    Clear/Shift Worksheet

    Choose to clear the entire worksheet, overwrite the existing data, shift the existing data, or overwrite with parameters when inserting the data.

    Target Worksheet

    Select or enter the worksheet destination for the output. Defaults to the current active worksheet.

    Target Type

    Choose to view the detailed results in a cell, range, or table.

    Target Cell/ Range/ Table

    Enter the cell or select the desired range or table for the output.

    Note: If the entered target range or table does not exist, a prompt allowing you to create the range or table displays.

    Fill Down Column

    Enter the number of columns that will contain other formulas or values to the right of the results grid in the worksheet. These columns fill down to match the number of records in the results. The valid values are 1, 2, 3, and so on.

    Clear a Range of Cells

    Enter the range of cells you want to clear before executing the formula. For example, A6:D16. This field is available when the target type is cell.

    Custom Layout

    Select the custom layout you want to use when generating the output. Click Create to create a new custom layout or click Edit to update an existing layout once selected. This opens the Customize Results Layout window which allows you to modify the output, for example, which fields to display or the order of the fields. See Custom Layout Editor for more information.

    Column Headings

    Select this checkbox to include the column headings from the business views.

    Autofit column size

    Select this checkbox to perform the AutoFit Column Width function of Excel.

    Clear Entire Sheet/ Range/ Table

    Select this checkbox to clear the entire target worksheet or the range or table when executing the formula.

    Parameters

    Displays the list of columns based on the selected business view.

    • Select the Select All checkbox to include all the columns or deselect the checkbox to exclude the columns from the formula. To select specific columns, select the checkbox against the columns.

    Note: If you select more than 125 parameters, an error message displays the number of parameters exceeding the limit that you must deselect.

    • Choose to view the details in a row or column.

    • You can use the following filters in the Value field against a column to display specific records:

      • Enter [value] to retrieve a single value.

      • Use * to retrieve all the values.

      • Use [value]* to retrieve values starting with that value.

      • Use *[value]* to retrieve values containing the value.

      • Use [value].[value] to retrieve values within a range. A one-year time range filter displays in the first row by default.

      • Use [value],[value] to retrieve the list of values.

      • Use /[value] to exclude a value.

      • Use ^[segment] to retrieve values in a segment list.

      • Use <[value] to retrieve values greater than that value.

      • Use >[value] to retrieve values less than that value.

      • Use <=[value] and >=[value] to retrieve values that are equal to and greater than or equal to and less than that value respectively.

    • Click the ellipses button (...) to view and select distinct parameter values from the list displayed in the look up window. Use the refresh button to repopulate the list of available values.

  2. You can perform one of the following actions:
    1. Click Preview to view the first twenty records of the parameters included in the business view in the Drill Down window based on the applied filters. You must select a business view in the Name field to use this function.

    2. Click Insert or Update to run the formula.

  3. Select Execute Reports from the Spreadsheet Server ribbon to execute all the formulas. To generate detail reports for only the selected GPXD formulas in the workbook, select Selected Reports > Selected Detail Reports (GPXD Formulas) from the drop-down menu or right-click the cell and select Spreadsheet Server > Generate Selected Detail Reports (GPXD).

    4. The results display in the Excel worksheet. The formula also displays the date and time of completion.

  4. Use the smart parameters (filters) in the Excel worksheet to derive the desired values for the columns.

Note: You can continue using the worksheet even when the formula execution is pending and not complete.

Was this article helpful?

We're sorry to hear that.

Powered by Zendesk