I have a form where a user enters the number of reports for the current year and the previous year. Based on these inputs, I need to say that there was either an increase or decrease of x% from the previous year.
I already set up an IF statement which writes "increase" or "decrease" based on the inputs, but for some reason I am having trouble getting the percentage to work. The formula for the precentage will be different depending on if the total number of reports has increased or decreased. Here is the IF statement I am having problems with:
{ =IF(RepTotal>PrevYearRep PrevYear/RepTotal RepTotal/PrevYear \# "0%" }
Where "RepTotal" is the number of reports for the current year, and "PrevYearRep" is the number of reports from the previous year.
It doesn't give me any kind of error, it just disappears with no output when I click toggle or update field.
What did I do wrong, and how do I make it work?
Please help