The Essential Project Forum

Hi

I have been running some tests using an import specification that imports a number column, fixed to 2 decimals places using the primitive float slot type. The numbers are being storing correctly in the Annual Cost Component, but the Overall Cost total does not agree with summation of the table records (rows) in the source spreadsheet.The Overall Cost total is not using the decimal values..

Am I missing something here?

https://drive.google.com/file/d/1BJHjv ... p=drivesdk


Thx.

It's the way the view is coded, it rounds the numbers. Primarily because the finance teams will almost certainly have different numbers, so we say the EA costs are indicative, they will be close but not exact - it reduces the amount of debate. Experience says it is easier, as long as we are clear when talking to Finance that our EA numbers are indicative.

If you do want exact numbers, the numbers are carried through to the view, so you need to remove the rounding.

Hope that helps

Hi

Thank you for the clarification.

I have loaded the data, with 6 significant figures and this has not corrected the difference; please could you explain how to ‘remove the rounding’?

Thank you in advance

It's quite an old view, but I can see it's using Math.round([some number]) in a number of places. This will probably need to be switched to parseFloat([some number].toFixed(2))

Have a go, if you are really stuck then let us know and we'll take a look (may not be immediate as we're quite busy)

Hi

I cloned the view to the user folder and modified the pie table entries as recommended, but they did not reconcile to the total of the records imported?

Hi, the image isn't coming through, can you reshare please

Attached

Can you share your code please. We suspect it's where the numbers are being rounded in the code in the existing version.

Thanks.

As requested:
1. rounding-errors.zip can be used to created the model, which has had the structure and data already loaded
2. user.zip, can be copied to the /tomcat/webapps/rounding-errors/user after you have published the rounding-errors.zip to the essential viewer

Hi

I have uploaded the model to Essential Cloud
AUPOC [EDITED BY ADMIN]

The equivalent view still has the rounding errors.

Hi,

We've discovered that there is an issue with how JS handles decimals, we've updated the view to address that, attached.
The repository shared looks different to the screenshot, so we can't compare the spreadsheet to the result, our test data looks OK. We didn't realise you were in POC, if there is still a discrepancy could you share your spreadsheet with your PoC manager (I presume at Akto) and we can reconcile the data with what you are seeing.

Thanks

Hi

The view now reconciles with the spreadsheet data now.
Thank you for your assistance.