Best Of

@Mahdiyar

Well, you did say you had a two year timescale so I went off the original requirements. With that said, I have you covered, but it does take a bit more steps.

Here is the final solution, but will go into detail after.

How was this done?

Summing over Native Time is very difficult because each detail member (in this case, the month) is a separate block of data. Due to this, create a Fake/Customized Month list, please make sure all of the months in your timescale are accounted for in your custom list.

Also, you will need to create another custom list for just the names of the months. I highly recommend giving a code to these month names (1-12) as it will make the mapping much easier.

Create a SYS module for the custom months list

Now, the fun stuff.

Before we get started, you will need to add these two line items to the original module. Note, Month is only dimensionalized by Time.

Create a module to get the data out of the original module to the customized Month module.

Value:'Min - V2'.Stage Value[LOOKUP: SYS Fake Months.Time list]

Month Text: IF Value = DIVIDE(1, 0) THEN BLANK ELSE IF Value = 'CALC Min V2'.Min[LOOKUP: SYS Fake Months.Month Name] THEN SYS Fake Months.Item txt ELSE BLANK

Now that we have the data at the Month level, we now need to get the data at the Month Name level.

Min: 'CALC Min V2 - Stage'.Value[MIN: SYS Fake Months.Month Name]

Month Text: 'CALC Min V2 - Stage'.Month Text[FIRSTNONBLANK: SYS Fake Months.Month Name]

Now the final product:

Desired Value: IF Desired Stage = DIVIDE(1, 0) THEN 0 ELSE Desired Stage

Desired Text: IF Desired Value > 0 THEN "This is min value for " & 'CALC Min V2'.Month Text[LOOKUP: Month] ELSE BLANK

Desired Stage: 'CALC Min V2'.Min[LOOKUP: Month]

Stage Value: IF Value = 0 THEN DIVIDE(1, 0) ELSE Value

for a final of

Special shoutout to @MarkWarren for the Divide(1,0) trick to get infinity on calcs which is larger than NaN.

Hope this helps,

Rob

@Olek P Sounds like an option worth considering for us to implement.