This discussion is archived
1 Reply Latest reply: May 5, 2008 10:40 PM by Dimitri Gielis RSS

APEX sub-total question

MikeLi Newbie
Currently Being Moderated
I have an APEX report that shows receivables and sales amounts by year, quarter and month. I have the page break by the first 2 columns which are year and quarter so I can show Quarterly Subtotal and Yearly Subtotal.

I have this derived column "DSO" based on formula: (receivables/sales)* number of days for the time period (i.e. num of days is 30 for each month, 90 for quarter and 365 for year). I want to use the receivables and sales subtotal values to derive the quarterly and yearly DSO values but don't know how to reference those values.

Any suggestions?
  • 1. Re: APEX sub-total question
    Dimitri Gielis Oracle ACE Director
    Currently Being Moderated
    Hi Mike,

    I'm not sure if I understand you correctly, but you want to use the calculated values that APEX did for you by using the break somewhere else?

    I wouldn't propose to get these values as you can't call them easily. However the solution I would prefer is by doing the calculation in your query. How far do you know SQL? for ex. using analytics would probably help you a lot. If you don't have any knowledge you might give us your query, another good resource is the asktom website.