Division calculation doesn't work in DVD

Prabhakar Y

Summary

Division calculation doesn't work in DVD

Content

i have a strange problem and looks silly . When Ian's dividing -30/40 should give me -0.75 and I set the decimal places display . it give me 0.0000 . any idea ?? 

But it when the calculat comes across same number like 40/40 it gives the right result as 1 . Where as all other cases simple 0 is. Even appearing

Gianni Ceresa

Just to "FYI", this is the default behaviour in OBIEE / DVD : integer division vs decimal division. The type of the values does matter and it's a common issue in IT when people ignore the types

Prabhakar Y

other best thing to cast the measures which involved in Division calculation to Decimal. data type setting losing the focus when we refresh the data source.

Prabhakar Y

I figured this out . You need to change measures data type to decimal , for all the measures which involved in percent calculation .