Aggregated Measure Rounding Problem

[Zenga]

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!

[kaushalsolanki]

Hi Zenga,

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

Regds,

Kaushal

[Zenga]

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