Skip to main content

Does A360 handle decimal values so you can do calculations

Hi @mohank06 ,

 

A360 can handle decimal values by making use of Number and Math packages. 

 

For example,

To multiply any number by 1.25% you can create a logic similar to the one shared below. You can tweak it as per your requirement.

 

Multiply with 1.25% 

However, there isn't any package that can find the greatest of 4 numbers using generic packages. You may write a Java script or Python script instead to achieve the same.

 

 Greatest of 4

 

 

Logic was made by Puneet from Automation Anywhere.


Now I Have Subtracted Two Column From An Excel sheet in AA360 But I Did Not Get The Decimal Value It left out the decimal value

 

 


Hi @mohank06 ,

 

What is the data type mentioned in the Excel? and what is the cell value that you are getting while selecting these mentioned cells?
 


 @Padmakumar I got it i tried with Number to String action Thank you.


Dear @mohank06,

 

Autodesk A360 is a cloud-based platform that provides a variety of tools and features for design, engineering, and collaboration. It is not a standalone calculator or spreadsheet application, so it does not have the same capabilities as software like Excel when it comes to handling decimal values and performing calculations.

However, A360 does provide some basic math functions that allow you to perform calculations on certain types of data. For example, you can use the "Calculate Field" function in the A360 Field Calculator to perform calculations on the values in a field or attribute of a design model. This can be useful for tasks like converting units or calculating totals.

If you need to perform more advanced calculations or work with decimal values in A360, you may need to use a separate calculator or spreadsheet application, or export the data to another tool for further analysis.

 

Regards,


Dear @mohank06,

 

Autodesk A360 is a cloud-based platform that provides a variety of tools and features for design, engineering, and collaboration. It is not a standalone calculator or spreadsheet application, so it does not have the same capabilities as software like Excel when it comes to handling decimal values and performing calculations.

However, A360 does provide some basic math functions that allow you to perform calculations on certain types of data. For example, you can use the "Calculate Field" function in the A360 Field Calculator to perform calculations on the values in a field or attribute of a design model. This can be useful for tasks like converting units or calculating totals.

If you need to perform more advanced calculations or work with decimal values in A360, you may need to use a separate calculator or spreadsheet application, or export the data to another tool for further analysis.

 

Regards,

Hi @Zaibi 

Think you are referring as Autodesk 360 as Automation 360? 


Try this

 


You can use Set Cell formula action in Excel Advanced package


@mohank06 

Verify you have enabled Improved number support.

 

 

 

 

HTH

Regards


Dear @mohank06,

 

Autodesk A360 is a cloud-based platform that provides a variety of tools and features for design, engineering, and collaboration. It is not a standalone calculator or spreadsheet application, so it does not have the same capabilities as software like Excel when it comes to handling decimal values and performing calculations.

However, A360 does provide some basic math functions that allow you to perform calculations on certain types of data. For example, you can use the "Calculate Field" function in the A360 Field Calculator to perform calculations on the values in a field or attribute of a design model. This can be useful for tasks like converting units or calculating totals.

If you need to perform more advanced calculations or work with decimal values in A360, you may need to use a separate calculator or spreadsheet application, or export the data to another tool for further analysis.

 

Regards,

Hi @Zaibi 

Think you are referring as Autodesk 360 as Automation 360? 

Exactly 😁


Reply