EGL: nVision and Excel Formula/Function on The Layout Definition
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****”
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?
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.
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