Aggregated Measure Rounding Problem

Zenga — Thu, 04 Aug 2016 01:28:40 GMT

Hi, I would like to check why the following formula works in Report -> Cross Tab and does not works in Exploration -> Cross Tab

( Avg [_ByGroup_] ('PRICE(MAX)'n) Round 100 )

Thanks!

Re: Aggregated Measure Rounding Problem

kaushalsolanki — Thu, 04 Aug 2016 06:30:03 GMT

Hi Zenga,

Can you please explain your issue, particularly where you are using this formula.

Regds,

Kaushal

Re: Aggregated Measure Rounding Problem

Zenga — Thu, 04 Aug 2016 08:40:27 GMT

This formula is used in the Aggregated Measure Field. When I use this field in Cross Tab in Exploration , it will have an error message "(mx.rpc::Fault)#0
content = (null)
errorID = 0
faultCode = "Server.Processing"
faultDetail = (null)
faultString = "com.sas.biv.exception.BivException : Round operator must have 1 operand (errorCode=GENERIC_EXCEPTION, params=null)"
message = "faultCode:Server.Processing faultString:'com.sas.biv.exception.BivException : Round operator must have 1 operand (errorCode=GENERIC_EXCEPTION, params=null)' faultDetail:'null'"
name = "Error"
rootCause = (Object)#1
    cause = (null)
    errorResponseCode = "GENERIC_EXCEPTION"
    localizedMessage = "Round operator must have 1 operand (errorCode=GENERIC_EXCEPTION, params=null)"
    message = "Round operator must have 1 operand (errorCode=GENERIC_EXCEPTION, params=null)"
    params = (null)
    suppressed = (Array)#2
null"

I do not have this problem when I use it in Line Chart in Exploration

I do not have this problem when I use it in Cross Tab in Report

topic Aggregated Measure Rounding Problem in SAS Visual Analytics

Aggregated Measure Rounding Problem

Re: Aggregated Measure Rounding Problem

Re: Aggregated Measure Rounding Problem