This is really helpful!
Will share with the team. We will definitely incorporate. Thanks.
1 Like
@ag.1 I think you can use this link to go straight to it:
https://redcarpet.prophix.com/forum/t/using-the-carry-forward-from-option/426/14
That’s a good way to do it!
1 Like
I think I’ve finally got my head around how this is working. Thanks a lot for sharing!
1 Like
Great method! Thanks for sharing
Interesting! I might have to try that! Thanks for sharing!
Nice! Thanks for sharing!
Thank you for sharing.
Wow…this is one of those ‘quality of life’ things that’s been requested of me and I just didn’t think it was possible. This is a great (and extremely creative) solution!!
1 Like
Thanks for sharing, definitely helpful!
great. thank you for sharing!
I just wanted to say THANK YOU @bob.smiley!!! I used this theory with Actuals =1 and Forecast =0, so the header row formula is if 1 then “Actual” else “Forecast”. I also was able to use that hidden row with a sum to be able to create an average per month of just the actual columns for our team to use while analyzing the future months! Definitely made my life easier!
5 Likes
Thank you, this is really helpful alternative for me to clarify which one is current closed month.
Donna, I use a similar trick to tell whether I’m dealing with a lead node or summary node in an elastic report group.
Using yet another leaf-calculated account which is a 1 at the leaf node for all types, my time dimension works this way:
1=month (leaf node)
4=quarter
12=year
For other dimensions the meaning varies, but i can often use it to interpret levels intelligently within a report.
1 Like
Interesting; I can’t think of a use internally for that…but interesting! I have a stat for number of days per month and use that to calculate averages per day…that’s the most creative I’ve gotten with stats in reporting! 
thank you! Great information
Thanks for this tip- very interesting assessment. We will try to incorporate this
Thank you so much for the detailed explanation!