Commas in Number format combined with Rounding in the Prepare Reciepe

Maleeha
Maleeha Registered Posts: 3 ✭✭✭

I have a column of USD figures and I have used the Prepare recipe to do the following 2 functions:

1. Convert Number format from Raw to English

2. Round the values to 0 decimal places

The column is detected as a Double - Integer. before trying to do these 2 functions. It seems I cannot do these 2 functions together as converting the numbers causes the values to not be recognised as a Double. I have tried changing the Double to several other options but none of them help to fix the issue. additionally it is showing the figures with at least 10 decimal places .

For context I am trying to publish USD figures to a dashboard by adding comma and round to an integer so that it can be easily viewed by senior management

Best Answer

Answers

  • Maleeha
    Maleeha Registered Posts: 3 ✭✭✭

    Playing around with it further, it seems I can get it to have commas and also round it up in the Prepare recipe, but it turns it into a string so is not really helpful if I want to create charts for the dashboard out of it. Is there another way to make this possible?

Setup Info
    Tags
      Help me…