Report Summaries Round Off

Above is a screenshot of my report. Net Premium = Gross Premium less Commissions less Claims. From those figures the calculations seem inaccurate but looking at the table the Gross Premium is actually 1.474m and it was rounded down to 1m. My question is that is there a way to change how the values are rounded off, so instead of 1m it can show maybe 1.5 ?

Hello,

Thank you for sending in the example.

The summary field does not allow for alot of control in regards to rounding. There is however an other option that would allow you to have more control over the output of this fields.

In my example I will be using the data from the Sample Ski Team database, where I have an Invoive summary value of $470,935,339 by using the standard summary this produces and output of $471m. To allow me to have a more accurate number displayed e.g. $470.94m I did the following:

1. Create a calculated field called 'Million' and give it the value of 1000000

2. Add this field to the report (You will see a column of just 1000000 for every row.

3. Click on the dropdown next to the field label and select 'Advanced Function'4. Select 'Division By Column' and select the column you wish to be divided by 1000000 (This will show the column as a decimal value e.g. $22,000 will now show as 0.022)

5. Next you will need to edit the format of the field so that you can add a prefix,a suffix and a decimal place value, in this example I will be using the prefix $ and the suffix m.

6. Within the Numeric Desplay Chart replace your current field with this new field (in my example 'Division by Million')

7. You will now see the SUM value of that column with the Prefix, Suffix and decimal place pulled through.

Hopefully following this example you will be able to have control over the decimal place. Which means you can produce outputs such as 1.4m, 1.47m, etc.

Please let me know if you have any further questions.

Kind regards,

Nathan Goddard

Thank you, let me try to implement the solution

Hi,

Youre very welcome, please let me know if you need any further assistance on this.

Kind regards,

Nathan Goddard

Hi,

I hope you are well.

I am just checking in to see if you have manage to try the implementation suggested?

Please can you let me know if you require any further assitance or if you are happy for this ticket to be close.

Kind regards,

Nathan Goddard

Hi,

Due to inactivity I have now marked this questions as answered. If you do require any further assistance please feel free to reach out to us.

Kind regards,

Nathan Goddard

Hie,

Did implement the solution but it didnt come out the way I wanted. I couldnt format the values as nicely as the automatic summaries. Dividing by a million does work but my data is too small for it to come out nicely, then tried a thousand and my data is too big. Thought of choosing something in-between a thousand and million like 100 000 but it would be too complicated to represent to the user. Will most likely stick to dividing with a million.

Regards

Hi,

Thank you for getting back to me. Would you mind sharing the figures your are trying to represent and I will see if I can offer any additional suggestions?

Kind regards,

Nathan Goddard

Hi,

Hope you are well.

I wanted to check in with you to see if you required any further assistance with this question or if you are happy for me to mark it as answered.

Kind regards,

Nathan Goddard