Division calculation doesn't work in DVD

Question

Summary

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 · Answer

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 · Answer

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 · Answer

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