Learn about Redwood and be one of the first to join the conversation

Visit Redwood Community
XRange issue — Cloud Customer Connect
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

XRange issue

Received Response
20
Views
5
Comments
edited Aug 2, 2018 2:36AM in Essbase 5 comments

Summary

XRange issue

Content

Hi All,

 

"May" = @Xrange("Jan"-> "Actual"->"Final","Apr"->"Actual"->"Final")-@Xrange("Jan"->"Current_Forecast"->"Current","Apr"->"Current_Forecast"->"Current")+

        "May"->"Current_Forecast"->"Current";

 

The above code sshowing the Error:

 

 

 

 

 

 

 

 

Essbase
Error(1200400): Error executing formula for [May] (line 0): scalar double
argument expected in function [@SUB]

 

 

Please help me how to write the code?

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!