We have updated Flexmonster Software License Agreement, effective as of September 30, 2024. Learn more about what’s changed.

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 November 22, 2021

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