This content has been marked as final. Show 7 replies
in your avg calculation.
there is no relation between col1 and col2. average is calculating on
AVERAGE(Evaluate ('olapdba.work_days_between (min(%1 ), max(%2))' as INT, "OBIEEMeasures"."First Days to Ship.OLAPDBA.ORDER_DIM.BOOKED_DATE" , "OBIEEMeasures"."Last Days to Ship.OLAPDBA.LINE_ATTRIBUTE_DIM.LINE_STAT_DATE" )
I was referring in general
for ex: avg formula something like
or a column value based on col1/col2
in this case I'm asking you to do as (col1*1.0)/col2
Can you try to use pivot in output and make sure 'Report based Totals' is checked on the AVG columns?
Another issue I noticed is OBIEE rounding problem.
for example in standard methods rounding
how can I get absolute rounding like standard methods?
Can you try CEILING math function to round the values
CEILING(column name )
cast as double for that column in repository.
hope this helps.