DAX Commands and Tips - Calculated Columns Issue

[Anonymous]

Hi.

I have 3 calculated columns:

Co1_1: = Units/Weeks

Result = 2.7

Col_2: = Capacity/(Col_1)/7

Result = 10.5

Col_3 = Col1*Col2

Result = 28.0

It should be 28.4

Any help.  Thank you

[Anonymous · Accepted solution]

Hello.  So far not solved yet.  All of my fields (columns) are Date type=Decimal & Format Decimal=Decimal Number.  All the calculation is doing is taking (L52_Avg_Mvmt)*L52_DOS_W) and it just keeps returning a whole number even with format set to decimals.

[ppm1]

I suspect you have the formatting for your columns to show one decimal place. Increase that on the two input columns and you will likely see that 28.0 is correct. The original values are used in the calculation, but the format string controls how it is displayed.

Pat

[Anonymous]

I took this same calculation out to excel (copied it from powerpivot).  If i have 2 decimal places it should show decimals and not whole numbers.  Any ideas?