AnsweredAssumed Answered

Calculated Attributes and Decimal Places Issue

Question asked by juan.segovia on Mar 28, 2012
Latest reply on Mar 30, 2012 by juan.segovia
I'm currently working with Clarity 13 on SQL 2008 R2.

I'm facing an issue when I create a calculated attribute:

I have 3 lookups with values from 1 to 5. Then my calculated attribute makes this operation: Sum((look1*0.4),(look2*0.3),(look3*0.3))

This for example if I select value 1 on each lookup will perform 1*0.4 + 1*0.3 + 1*0.3. This will populate 1.00 as a result. The issue is when my results ends up with decimal places on it. If I make the following: 1*0.4 + 1*0.3 + 2*0.3 this should be returning me 1.3 and it gives me 13.00 Same thing happens with all the rest of my operations.

Do you have clues on why this is happening is this related with any server, db or Clarity configuration I might be missing?

Thanks in advance.

Juan.

Outcomes