I’m having two problems in two different reports. I’d really appreciate your help.
A have a column in a report with the number of days between 2 dates.
I want to count the number of days > 45 and the number of days < 45 and based upon these counts I have to do a calculation.
My understanding is that it should be done using a self join in the universe. Please let me know if this could be done at the report level.
I am sure this is very simple and I dont know what I am missing.
I have a master-master-detail report. (sub-sections with in section). I performed sum and average on each sub-sections and it is working fine.
When i try to drag the values of sum and average from the footer to the sub-section area, I get a different result than what appears at the footer. (I think this is what it is doing…it does not include duplicates for calculating the sum and average in the cell).
Create a variable which check for day difference value.
Var = if DayDiffCol >45 then 1 else 0
Now in your calculation variable use Var.
CalcVar = if ( Var=1 then “X” else “Y”)
Prob 2 :
Sum and Average at the report footer is showing the sum all th data in that section.
Use View structure and see where u have put Sum and Average variables.
Thanks alot for your reply. I did the 1/0 calculation earlier but how would I be able to count the number of times 1 appear in that column.
My understanding is that you can calculate across the columns in BO reporter, but you cant perform calculations down the row ; unless you are using simple aggregate fns or you can use pl/sql.
Now, lets say that I have a column with
1
1
1
0
0
1
0
How would I be able to get
Count of Ones = 4
Count of Zeroes = 3
This was a nice idea and I could get a count now using Sum on the column. Ultimately I wanted the percentage of cases in which the case was handled in 45 days…ie percentage of 1’s and percentage of 0’s (if the case is not handled in 45 days).
Using Sum as the aggregate on the report column allows me to get the count, and it creates a formula. When i try to calculate the above percentages and display the result in a cell, it does not calculate and instead shows “#COMPUTION”.
I am having a similar case where I need to sum the values of 1 and 0 separately
For Example
Yes/No (Dimension Field)
1
1
1
0
1
0
0
I need the result to be number of 1s = 4 and number of zeroes =3. I tried the solution mentioned above and am getting number of 1s to be 1 instead of 4. And if I say
Count(<Yes/No>) Where (<Yes/No>=“1”), I am getting #IERR error in a free standing cell. Kindly help. Thanks.
Thanks for the input Mraty. I tried the suggestion in a free standing cell and getting the #IERR error message again. Please let me know if there is any other means of doing this calculation. Thanks.