Can anyone help me how to set currency format in script report. I have tried this script format but it doesn’t change to currency.
chart = {
"data": {
"labels": all_projects,
"datasets": [
{
"name": "Costing",
"values": [project_costing.get(p, 0) for p in all_projects]
},
{
"name": "Billing",
"values": [project_billing.get(p, 0) for p in all_projects]
}
]
},
"type": "bar",
"currency": "USD",
"format": "currency"
}