SQL Language (MOSC)

MOSC Banner

how do I create running quarter and year to date totals in months where there is no detail activity

edited May 14, 2013 11:12AM in SQL Language (MOSC) 2 commentsAnswered
 I am using this partition statement which works great as long as there are source records for the fields specified for each month.When there are not all source records in a subsequent month then this does not create a value which returns in correct summarization
If I have a January amount of $100 for D_DISTREP_SKEY  but in February then there isn t a record i want the $100 from the prior month to also show in February which is not happening.
What do I need to add to this to make the prior month amounts carry forward even when there is no current month activity ?

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