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
There was an error rendering this rich post.
Hi all, The Client ID and Client Secret are available, intended for uploading and downloading files. Could anyone advise how to use these credentials DIRECTLY to make API requests? Thank you!
I have A6 as the parent list and two sibling lists: A6.5 and A7. The A7 list includes an attribute that maps to A6.5. In the UX, the user will select A6.5 using a content selector, and the grid (dimensioned by A7) should display only the A7 items associated with that selected A6.5. Since the selector is a page context andβ¦
