Log in to AnswerLog in to Follow
YITONG LYU
19Views
3Comments
Solved
[Data Grid Sample] How do I remove the dollar sign($) in front of the amount.
Question
DataGrid
Forge
Traditional Web
Data Grid Sample
Forge component by OutSystems R&D
Application Type
Traditional Web
Service Studio Version
11.50.12 (Build 48233)
Platform Version
11.13.0 (Build 31107)

Hi everyone

I have some data from Json. I want to format the data that the data type is Currency.

How do I remove the dollar sign($) in front of the amount when I use the Data Gird?

I have changed the Symbol property of the Data Grid to "", but it doesn't work.

Otherwise, why are there parentheses when the value of a negative number is displayed on the screen?

How can I display negative values normally?

In Json : -2366.88  In Data Grid : ($2366.88)

In Json : 9204.55   In Data Grid : $9204.55


Any suggestion is appreciated.

Kind Regards

0
0
27 Aug

Hi @YITONG LYU ,

I never used this, but after some research, the currency WB put the default symbol if the variable is empty ($).

So you should use the Number WB, and if not mistaken this config should work

Used this based on:

https://www.grapecity.com/wijmo/api/classes/wijmo_input.inputnumber.html#format

and for the N https://stackoverflow.com/questions/17541307/remove-from-tostring0c-formatted-number


Regards,

Luis

1
0
27 Aug

Hi @YITONG LYU , did this solution worked? If yes, close the thread as marking the post that resolved the problem as the “solution”


regards,

Luis Oliveira

0
0
28 Aug

Replying to Luis Filipe Oliveira's comment on 28 Aug 2021 16:12:59


Hi @Luis Filipe Oliveira 

Deeply appreciated. 

I tried it on the program. 

This exactly solves my problem.

Thanks a lot.

1
0
30 Aug
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.