I am working in MS Office 2007. I am trying to calculate a percent of a change in two fields. I would like to display like this:
If LY_PAT_COUNT=0 print %100 (or 1)
if TY_PAT_COUNT=0 print -%100 (or -1)
otherwise, [TY_PAT_COUNT]-[LY_PAT_COUNT])/[LY_PAT_COUNT] normal figure.
I came up with this formula but getting the wrong number of arguments error.