divided by zero

Mohamed

Why when using this formula get exception divided by zero
[IIf([rpt_Transactions.QuantityBalance] == 0,0,([rpt_Transactions.AmountBalance] / [rpt_Transactions.QuantityBalance]) )]

and when use this it works
[[rpt_Transactions.QuantityBalance] == 0 ? 0:[rpt_Transactions.AmountBalance] / [rpt_Transactions.QuantityBalance] ] ???


other question What is language that used for writing expression and is there any documentation for it ???

AlexTZ

Hello,

IIf function calculates both parameters, truePart and falsePart, independent of condition, then returns truePart or falsePart. It's a standard behavior of any .Net function.

Please read the user's manual:
http://fast-report.com/documentation/UserM...expressions.htm

Mohamed

thanks.. missing this manual