I created an expression to calculate the difference between to quantity fields and display as a negative or positive percentage. However, if the two fields have a value of zero the expression returns the #Error.
Expression: TDA_Qty_Diff: ([FY13_TDA_TOTAL]-[FY08_TDA_TOTAL])/[FY13_TDA_TOTAL]
How do I modify the expression to return a 0% instead of a #Error?
Thanks for your help in advance!
v/r,
James Eggert
__._,_.___
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (1) |
.
__,_._,___
Tidak ada komentar:
Posting Komentar