FSG and XML if statements
I have a custom template for my FSG.
the cell <?fsg:RptCell[5]?> is what I want to make a change to as my percentage is sometimes showing as negative.
In the FSG itself on my revenue rows I need to do a change sign so the revenue shows as positive.
budget actuals %
% = actuals / budget.
so my report shows
REVENUE CHANGE SIGN
budget = 255678204
actual = 16089851
% = -6.29%
EXPENSE ROW do not change sign
budget = 987254
actual = 260238
% = 26.36% CORRECT
I have not been able to figue out how to show revenues as positive and make the percent positive.
So my next thought is to change the template....but I do not know XML that well.