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

@COUNT WITH SKIPNONE AND @XRANGE unexpected behaviour

in Planning 11 comments

Hello everyone,

I am using the @COUNT to calculate the count for the number of months from Jun-FY22 to Sep-F23 :

OFS_Calculated= @COUNT(skipnone, @XRANGE( FY22->Jun,FY23->Sep))

However, instead of giving me the result is 16 months, this function gave me 39 months.

Has anyone met this error before?

Please share how you can fix it.

Thanks!

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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