SQL*Plus (MOSC)

MOSC Banner

how to add ytd sales each month

edited Sep 14, 2023 1:03PM in SQL*Plus (MOSC) 4 commentsAnswered ✓

Hi All,

Working on Oracle ERP

Version : 12.2.10

actuall i my requirement is to show ytd sales every month, for example if the parameter is from 01-jan-23 to 31-mar-23 then

for jan=2023 jan value will be jan value

for feb - jan+feb

and for march - jan+feb+mar

here ytd sales clumn i have manually added just for example, please i need some help, i have very long query so i have attached the file

and calling function from main query


please i need help

Regards

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