Oracle Transactional Business Intelligence

Products Banner

Can we add a filter where we can compare one Column with other 'Calculated Column'

14
Views
0
Comments

Summary

Filter Based on Calculated Column

Content

Hi Experts,

I have a OTBI Report where I am fetching the Person Details along with who columns.

Also I am having a calulated column which return the MIN(LAST_UPDATE_DATE)

Can i have a filter such that LAST_UPDATE_DATE > = MIN(LAST_UPDATE_DATE)

As a second step we would like to know can we replace MIN(LAST_UPDATE_DATE) with some bind variable

Thanks

Ashish