I have a derived field which calculats total hours worked. I would like to create a field that looks at that field and if the amount is over a set amount 80 it returns 80, but if it is less it returns the calculated amount. I am using ReportSmith and don't have case statement available I can use @decode but when I do I continue to get missing right parenthesis.
Red Flag Submitted
Thank you for helping keep Tek-Tips Forums free from inappropriate posts. The Tek-Tips staff will check this out and take appropriate action.
Reply To This Thread
Posting in the Tek-Tips forums is a member-only feature.