Fusion Manage Forum
Welcome to Autodesk’s Fusion Manage (formerly Fusion 360 Manage) Forum. Share your knowledge, ask questions, and explore popular Fusion Manage topics.
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Computed Money fields showing more than 2 decimal places

6 REPLIES 6
SOLVED
Reply
Message 1 of 7
fhmurray
861 Views, 6 Replies

Computed Money fields showing more than 2 decimal places

Hi,

I have noticed that where Money type fields are computed, they are showing more than 2 decimal places.  In one case it is showing a huge number of decimal places.  I can't see where to change this.  I'm guessing there might be a standard instruction to put in the computed field formula to ensure it shows the answer just to 2DP, but I don't know what this is.  Can anyone advise?

 

Thanks,

Fiona

6 REPLIES 6
Message 2 of 7
bastien.mazeran
in reply to: fhmurray

Hi Fiona,

 

I am not sure I fully understand what you mean by computed money field. In PLM 360 you can create a new field and set its type to Money. At which point, the field has a built-in validation that enforces the two decimal places rule. You can test this yourself by adding a new field to your item details page and set the field to type Money, you will find that you cannot input a value of 13.435, but you will be able to input 13 or 13.4 or 13.43. 

 

Are you using a field of a different type e.g. integer or float where you use a computed formula?

 

 



Bastien Mazeran

Technical Support Specialist

Tags (1)
Message 3 of 7
fhmurray
in reply to: bastien.mazeran

Hi Bastien,

 

I have come across this problem in both a matrix and the grid - in places it is to do with the field being computed and having the type 'Money' but showing >2 decimal places.  In the first example below, it is where a computed field has the type 'Integer' but is showing a vast number of decimal places.  Both seem to be where calculations involving percentages are concerned, but this may be coincidental.

 

1) In the Matrix example, the Contingency % is showing a huge number of decimal places despite being set as an Integer.  The calculatation to get this answer is: (SCENARIO_CONTINGENCY_AMOUNT / (QUOTED_SALE_PRICE + PRICE_VARIATIONS))*100

 

PLM360_contingency_multiple_decimal_places.jpg

 

 

2) In the Grid example below, the 'VAT per item cost' is generated by computing 'PO_TOTAL_NET_ITEM_PRICE * 0.2', with the format of the field set as 'Money'  - but the result is showing 3 decimal places.  

 

Similarly the 'Gross Order Cost'  is computed with '((PO_TOTAL_NET_ITEM_PRICE * PO_QUANTITY) + PO_DELIVERY_CHARGE) * 1.2' and is also designated as 'Money' type, but shows 3 decimal places.

 

Any ideas?

 

PLM360_money_fields_with_2+_decimnal_places.jpg

Message 4 of 7
jpiggee
in reply to: fhmurray

Hi Fiona,

 

When dealing with computed fields, it will in a way bend the rules of enforcement imposed by the field type. To correct this issue you can change your compute field formula to:

 

ROUND(((PO_TOTAL_NET_ITEM_PRICE * PO_QUANTITY) + PO_DELIVERY_CHARGE) * 1.2,0)

 

This will force the number to round to the nearest 2 decimal places and will hold the integrity of the field in question.

Joseph Piggee
Fusion 360 Administrator
TPI Composites
jpiggee@tpicomposites.com
Message 5 of 7
fhmurray
in reply to: jpiggee

Hi Joe,

 

Thanks very much for the reply.  That's very helpful.  I take it it is the ,0 before the close of the bracket that does this?  In this case of a money field then it would round to decimal places because the 0 would mean don't add any more decimal places?  If this were used for an integer, it wouldn't add any decimal places at all, am I right?

 

Similarly, if I did want it to show 2 decimal places I could add ,2 instead?

 

 

Thanks for the prompt response.

 

Fiona

Message 6 of 7
jpiggee
in reply to: fhmurray

Hi Fiona,

 

The “ROUND(,0) command is telling the system to round to the nearest 2 decimal places, in an money related field, but in an integer setting it would be ROUND(,2).

For more info on the round commands and SQL commands in general see http://w3schools.com

Joseph Piggee
Fusion 360 Administrator
TPI Composites
jpiggee@tpicomposites.com
Message 7 of 7
fhmurray
in reply to: jpiggee

Thanks Joe.  I'll take a look.

 

 

Can't find what you're looking for? Ask the community or share your knowledge.

Post to forums  

Autodesk Design & Make Report