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