-
Re: How to avoid references to specific years in a formula
There are times when YearValue cannot be used: 1) When the module in which it is being used has no time value (e.g. I have a module which I use to inflation annual values by inflation) 2) When you ne…1 -
Re: Rank function on LineItem Subset
Solved by adding 3d item - 'PNL account' (list PNL formatted) in Blueprint it takes value from PNL subset by item() formula also made expansion to Rank formula by adding 'PNL account…1 -
Re: linitem options (Start of section, Brought forward)
I believe start of section in the blueprint allows you utilise any line item list selection changes to the remainder of the line items. If not a large section probably best to just change the 'A…1 -
Re: RANK function options
I wasn't able to include both group parameters in one rank function, but I was able to iterate a rank over Group 1 then Group 2. Result = RANK(Source, Direction, Ties, Include, Group) Result2 = …1 -
Re: RANK function options
Hi Ryan lets say we have target module where we have target lists/dimensions and where we want to build ranking across these lists it's 5 step solution for case with 2,3 and more groupping ties …1

