I'm trying to divide integers in a Forest & Trees function and I keep getting a whole number when it should be a decimal. How do you get a decimal out of a division (i.e. 3/10 = .30)?

Document ID : KB000054251
Last Modified Date : 14/02/2018
Show Technical Document Details

Description:

How do you get a decimal out of a division (i.e. 3/10 = .30)?

Solution:

Getting a decimal out of a division in Forest & Trees depends on your data types. Go to Tools>Data Formats and check what the Double format is set to. If it is set to default, it is using the Windows Regional Settings for the format. So either make sure your regional settings are correct, or specify something like #.## here in Data Formats instead of default. That should show you .30 instead of 0 when doing your division.