Exploring, modeling, predicting and reporting with SAS Visual Analytics and SAS Visual Statistics

Aggregated Measure Rounding Problem

Reply
New Contributor
Posts: 2

Aggregated Measure Rounding Problem

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!

Contributor
Posts: 55

Re: Aggregated Measure Rounding Problem

Hi Zenga,

 

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

 

Regds,

Kaushal

New Contributor
Posts: 2

Re: Aggregated Measure Rounding Problem

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 = "faultCodeSmiley Frustratederver.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

 

Attachment
Post a Question
Discussion Stats
  • 2 replies
  • 144 views
  • 0 likes
  • 2 in conversation