Get Free Trial

How to set default currency Symbol format?

Answered
Dor asked on November 21, 2021

Hello. 
I want to set percent on the “Percent Traded Volume” column and i dont know where im worng..
please help me with this issue. 
my configuration is :

{
    “dataSource”: {
        “dataSourceType”: “csv”,
        “filename”: “”
    },
    “slice”: {
        “rows”: [
            {
                “uniqueName”: “execution_type_name”,
                “sort”: “asc”
            }
        ],
        “columns”: [
            {
                “uniqueName”: “[Measures]”,
                “active”: true,
                “sort”: “asc”
            }
        ],
        “measures”: [
            {
                “uniqueName”: “Volume”,
                “caption”: “Sum per type”,
                “active”: true
            },
            {
                “uniqueName”: “Volume”,
                “aggregation”: “percentofcolumn”,
                “caption”: “Percent Traded Volume”,
                “active”: true
            }
        ],
        “expands”: {
            “expandAll”: false,
            “rows”: [
                {
                    “tuple”: [
                        “destination.[france]”
                    ]
                }
            ],
            “columns”: [
                {
                    “tuple”: [
                        “category.[accessories]”
                    ]
                }
            ]
        },
        “drills”: {
            “drillAll”: false
        }
    },
    “options”: {
        “viewType”: “grid”,
        “grid”: {
            “type”: “compact”,
            “title”: “Traded Volume”,
            “showFilter”: true,
            “showHeaders”: true,
            “fitGridlines”: false,
            “showTotals”: true,
            “showGrandTotals”: “on”,
            “showExtraTotalLabels”: false,
            “showHierarchies”: true,
            “showHierarchyCaptions”: true,
            “showReportFiltersArea”: true,
            “pagesFilterLayout”: “horizontal”
        },
        “chart”: {
            “type”: “pie”,
            “title”: “Traded Volume”,
            “showFilter”: true,
            “labelsHierarchy”: “”,
            “multipleMeasures”: false,
            “oneLevel”: false,
            “autoRange”: false,
            “reversedAxes”: false,
            “showLegendButton”: false,
            “showAllLabels”: false,
            “showMeasures”: true,
            “showOneMeasureSelection”: true,
            “showWarning”: true,
            “activeMeasure”: “”
        },
        “configuratorActive”: false,
        “configuratorButton”: true,
        “configuratorMatchHeight”: false,
        “showAggregations”: true,
        “showCalculatedValuesButton”: true,
        “editing”: false,
        “drillThrough”: true,
        “showDrillThroughConfigurator”: true,
        “sorting”: “on”,
        “datePattern”: “dd/MM/yyyy”,
        “dateTimePattern”: “dd/MM/yyyy HH:mm:ss”,
        “saveAllFormats”: false,
        “showDefaultSlice”: true,
        “showEmptyData”: false,
        “defaultHierarchySortName”: “asc”,
        “selectEmptyCells”: true,
        “showOutdatedDataAlert”: false
    },
    “formats”: [
        {
            “name”: “”,
            “thousandsSeparator”: “,”,
            “decimalSeparator”: “.”,
            “decimalPlaces”: 3,
            “maxSymbols”: 20,
            “currencySymbol”: “%”,
            “currencySymbolAlign”: “left”,
            “nullValue”: ” “,
            “infinityValue”: “Infinity”,
            “divideByZeroValue”: “Infinity”,
            “textAlign”: “left”
        }
    ]
}

 
Thank you

1 answer

Public
Vera Didenko Vera Didenko Flexmonster 7 days ago

Hello,
 
Thank you for reaching out to us.
 
It seems we answered your question in the following Support Ticket: https://www.flexmonster.com/question/cell-symbol/.
 
Please let us know if it helps solve the issue.
 
Kind regards,
Vera

Please login or Register to Submit Answer