divided by zero
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 ???
[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 ???
Comments
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