Issues while implementing a formula in scripted calculation view

[former_member212706]

Dear Experts,

We are using a scripted calculation view and have used a formula

POWER

(((( "COL1" / Db ) - WDBT ) / ( 4 - WDBT )) , 1 ) AS "COL3"

The issue here is that when i calculate it manually it differed from the result in calc. view. When i explored further by dissseminating the formula i was surprised to see that the numerator was giving me the problem

the numerator's ("COL1" / Db) is working fine  but when i subtract WDBT it causes me issues ("COL1" / Db) - WDBT should have been 1.1522.... but rather it shows as 1.252..... which means that the value of WDBT is read as 1 incorreclty or is this because of something else(like datatype conversion).

Because if  in the denominator value is read correctly why it isnt read correctly in the numerator.

Please help me here.

Thanks,

Rajesh.

[former_member212706]

Dear experts,

To make it simpler i hardcoded 1.1 in place of WDBT, the denominatore gives the correct value. Again the numerator is causing problems. Only '1' is getting subtracted from the result of ("COL1" / Db) , instead of 1.1 getting subtracted.

Please help me. why is 1.1 being read as 1 while subtration , that too only in the numerator.

Thanks,

Rajesh.

[former_member182114]

Hi Rajesh,

What is the object that you selecting from?

Maybe it's an issue with calculate after aggregation.

Please what is around this formula.

Regards, Fernando Da Rós