Skip to Content
2
Jul 26, 2020 at 03:34 PM

Division functionality in BODS

474 Views

Hi Experts,

I have to do a calculation on two columns and the data types of two column is Decimals.

Query.Amount is type P(10) decimals 2,

Query.Price is type P(10) decimals 2,

The result column is Net Revenue = Amount/Price.

The out put should be 8068.93/3000.00 = 2.68

I have tried below function, but I am not getting correct results.

ifthenelse((Query.Amount = 0 or Query.Price = 0), 0.00, Query.Amount / Query.Price)

Please help me to resolve this.


Regards,

Rag