Hi @Krishnarao,
There is no easy way, and that's why native way is usually better, but there are few alternatives - generally using Ratio summary. Depending on the exact module structure, I think either 1st or 2nd should work: 1. Using RANK() to determine what is the last (or first, as solution is similar) period - or maybe you already have that in your SYS module:
BUT: If you have more levels of summaries, this will not work.
2. Using TEXT() to get number in as text, then you can get the "closing balance" using "last non-blank", and convert back to number using VALUE():
As you can see on the screenshot it should work on all levels (so even if you have years, total for all periods etc.), but you might have rare problems with conversion of the numbers to text and vice versa. Notice that in the "ratio" and "1" line items I used the full list, you can use just upper level (so Months dimension), but then it will only work if you don't have other dimensions in the source "Input" line item.
@Krishnarao
Why are you using a Custom Time hierarchy instead of the Native Time hierarchy where Closing Balance is built in?
That was actually a example screen shot. My my real model build was completly using Custom Time. Not I have a requirement to for last week's data in the summary.
@rob_marshall
@M.Kierepka Workes perfect Thankyou so much
Hi - I cannot seem to create a migration for Assignment 3 and it will not allow me to update the hierarchy and proceed further. It seems to think that a link has already been created, but I don't see anything. Any ideas?
There was an error rendering this rich post.
A quick reminder of the Bulk Copy functionality. Bulk Copy allows you copy large volumes of data from one slice of a model to another in a single, optimised operation, instead of using formulas or imports. Use case: copy a version (RF1) into a prior year version (PY RF1) using a versions list to allow for year-on-yearβ¦
