Getting error CRX-API-0003 when conditionally formatting time interval --SOLVED

[cabaynes]

EDIT: I GOT IT TO WORK!

My response time data item "response time" was a calculation "(end time - start time)" and it would not let me conditionally format that data item as anything without throwing an error. What I did was created a new data item called "response time 2" and all I did was throw "response time" inside, so that it was just duplicating my response time data item, but AFTER it had been calculated.

Then I was able to replace the "response time" data item in my crosstab with "response time 2" and then was able to format it using a number (rather than an interval). The number I found out read the time as milliseconds, so I wanted everything over 9 minutes to be highlighted, therefore I used the number 540,000 in the conditional formating and VOILA! It works!

Original problem below:

Hi all, first post here.

I have a report that is counting and averaging response times within a cross tab. It runs fine but I have been trying to conditionally format the response time data item to highlight the background when the response time is greater than 9 minutes. My response time data item is setup as a "Time Interval" in the crosstab and displays correctly. However when I try to conditionally format it using the "interval range" and I enter in 9 minutes as the time, I am then presented with this error upon running the report:

CRX-API-0003

      A data type error ocurred at or near the position '48' in expression: '[Avg JP Time by Hour of Day].[Completion Time1] >= string2DTinterval("0 00:09:00.000") '. The operand types ('double,interval2') for operator '>=' are not compatible.

RSV-SRV-0042 Trace back:RSReportService.cpp(805): crxException: CCL_CAUGHT: RSReportService::process()RSReportServiceMethod.cpp(265): crxException: CCL_RETHROW: RSReportServiceMethod::process(): asynchWait_RequestRSASyncExecutionThread.cpp(787): crxException: RSASyncExecutionThread::checkExceptionRSASyncExecutionThread.cpp(224): crxException: CCL_CAUGHT: RSASyncExecutionThread::run(): promptPagingForward_RequestRSASyncExecutionThread.cpp(837): crxException: CCL_RETHROW: RSASyncExecutionThread::processCommand(): promptPagingForward_RequestExecution/RSRenderExecution.cpp(606): crxException: CCL_RETHROW: RSRenderExecution::executeAssembly/RSDocAssemblyDispatch.cpp(277): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSLayoutAssembly.cpp(77): crxException: CCL_RETHROW: RSLayoutAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSReportPagesAssembly.cpp(176): crxException: CCL_RETHROW: RSReportPagesAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageSetAssembly.cpp(414): crxException: CCL_RETHROW: RSPageSetAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageGroupAssembly.cpp(483): crxException: CCL_RETHROW: RSPageSetAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSPageAssembly.cpp(300): crxException: CCL_RETHROW: RSPageAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableRowAssembly.cpp(173): crxException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): crxException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableAssembly.cpp(110): crxException: CCL_RETHROW: RSTableAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSTableRowAssembly.cpp(173): crxException: CCL_RETHROW: RSTableRowAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyAssembly/RSTableCellAssembly.cpp(135): crxException: CCL_RETHROW: RSTableCellAssembly::assembleAssembly/RSDocAssemblyDispatch.cpp(344): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchChildrenAssemblyForwardAssembly/RSDocAssemblyDispatch.cpp(294): crxException: CCL_RETHROW: RSDocAssemblyDispatch::dispatchAssemblyRom/RSConditionalExpression.cpp(210): crxException: CCL_RETHROW: RSConditionalExpression::evaluateExpressionRSExpression.cpp(140): crxException: CCL_THROW: RSExpression::compile

I'm still quite new to cognos. Where should I start looking?

Thank you!
Charles