Closing balance in summary

Accepted answers

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.

All comments

rob_marshall

@Krishnarao

Why are you using a Custom Time hierarchy instead of the Native Time hierarchy where Closing Balance is built in?

Krishnarao

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.

Krishnarao

@rob_marshall

M.Kierepka

Hi @Krishnarao,

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():

Krishnarao

@M.Kierepka

Workes perfect Thankyou so much

Quick Links

Can you help?

Unanswered questions

Different Subsets of Parent Lists in Input & Output Modules
I have 2 lists used in modelling, In Input module I'm using subset of territories from Country List and subset of Regions from Flat list. But in Output module,Its reversed, I'm using subset of regions from Country list and subset of territories from flat list.How to derive the numbers from input to output module. I do have…
Is there a way to turn off the Show Comments Summary panel in UX pages with Comments?
This shows all comments across all data to all users with access to the UX page. This is not appropriate for any UX which might contain security access sensitive data. Comments on grids and cards ARE security dependent. That works fine. But anyone with access to the page can open this Summary Panel and see ALL comments…
Are there any plans to support actions to rename or delete native Versions?
If anyone is aware of idea exchange ideas that are currently being evaluated by the product team, if you don't mind linking them here, would love to give them an upvote. Thanks!