Hi, I'm trying to setup a variance account under UD8 that will calculate
the variance between the current year last 12 months and the prior year
last 12 moths. Any suggestions on how to write this formula? Thanks.
Hi,I'm working on clearing data from a Plan scenario and ran across this
error. Has anyone encountered the image below? If so, what did you need
to do to clear the data out?
Hi, I have a saved report setup with XFGets. One of the dimensions on
the report points to the member "Top." Is there a way to have the XFGet
show Top of the dimension and exclude a base member? Thanks.
I'm working on a cube view that displays reporting data in a quarterly
trend. The end user would select which quarter they want displayed and
the CV would display that quarter along with the 4 previous quarters.
Ex. User selects 2022Q1 and then CV di...
This is my first time creating a book. I'm working on creating a book
that presents an income statement by location. The ideal outcome is that
the IS is displaying location at the top and each subsequent page
displays a child location member. I have ...
Thanks for the recommendation on the alternate hierarchy. I will be skip
that since this is more like a one off request. I’m still new to XFGets.
How would you write a subtraction of an XFGet within the same cell to
exclude the base member?
Hi Peter, I took a look at the base members under the view dimension and
unfortunately they are not going to work the way I am going to need them
to. Since the CV I am making will display 5 quarters I will technically
need a trailing15monthaverage ba...
Hey, Following up on this. How would you write a formula to take the
average of the current quarter selected by the user + the prior 4
quarters? Thanks.