Ok. I'm new at this expression stuff.
The expression below figures out the percentage of what they have left to spend out of the budget. It works fine if they're on the plus side of their budget, the problem is that once the percentage figures out negative. What should I add to the expression below to have the pecentage be negative, for example "-36.24%" OR enter a phrase, for example "Over Expended."
=[Text86]/IIf([subrptTotalBudget].Report.[HasData],[subrptTotalBudget].Report![SumOf1stQtr],0)
The expression below figures out the percentage of what they have left to spend out of the budget. It works fine if they're on the plus side of their budget, the problem is that once the percentage figures out negative. What should I add to the expression below to have the pecentage be negative, for example "-36.24%" OR enter a phrase, for example "Over Expended."
=[Text86]/IIf([subrptTotalBudget].Report.[HasData],[subrptTotalBudget].Report![SumOf1stQtr],0)
