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!
Hi Zenga,
Can you please explain your issue, particularly where you are using this formula.
Regds,
Kaushal
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
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!See how to use one filter for multiple data sources by mapping your data from SAS’ Alexandria McCall.
Find more tutorials on the SAS Users YouTube channel.