General Ledger - EBS (MOSC)

MOSC Banner

FSG and XML if statements

edited Mar 29, 2016 3:09PM in General Ledger - EBS (MOSC) Question

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center