Demantra Solutions - EBS (MOSC)

MOSC Banner

Hide time on worksheet

edited Jul 19, 2019 5:00AM in Demantra Solutions - EBS (MOSC) 1 commentAnswered

I want to hide time periods that are showing on a worksheet and only show current and future periods. 

The reason I am currently having to include past time is because of a series calculation. 

I have a series (call it Series A)  that is based on another series (call it series using the value of series B, 24 months prior.  Client expression SeriesB[-24].   

Note that series  B is calculated at worksheet time too.

Series A client expression            Series B[-24]

Series B client expression            calculated based on another saved series ex.  sum(nvl(branch_data.dmd_lg1_r,  0 ))

The only way to populate series A is to also include series B and increase the time period on the worksheet to include data 24 months prior.

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

EBS Demantra Tags

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center