EGL: nVision and Excel Formula/Function on The Layout Definition

(Doc ID 611347.1)

Last updated on SEPTEMBER 14, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 7.5 to 9.1 [Release 7.5 to 9]
Information in this document applies to any platform.
“****Checked for Relevance on 30-Jan-2015****”


Symptoms


Can nVision recognize an IF statement on the runtime to be able to know which criteria it needs to select?
Customer wants to specify it in the column that if the period is YTD, use this ledger, else, if the period is YTD-1, use thiatledger. Is it possible to do that?
For example:
Customer has 2 ledgers for this fiscal year, because they changed their fiscal year in the mid stream.
In nVision, they want nVision to be able to recognize which ledger it needs to use for a certain year.  For example: If Fiscal Year = 2002, use Ledger B, otherwise, use Ledger A. They have defined a name for %FY4% as 'fiscalyear'. Customer specified the definition for Ledger A in column X row 1, and Ledger B in column Y row 1. And then on cell D1, they specified an IF statement: @IF (fiscalyear =2002,Y1,X1).
When nVision runs, eventhough the Fiscal Year is 2002, it doesn't pickup the definition from cell Y1, but from X1.

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms