Minimum possible value in Dimension

[NickP_DF]

Hello guys,

I need to get the minimun value in a set of (selectable) date, so that I can check if a date in a record is less or greather than it and print the record or not in a pivot table.

I've tried to set a calculate dimension as "If GanttDate>=Min(DeliveryDate), OrderNumber, Null())" and check the relative flag "Suppress When Value is Null", but this issue doesn't work (I get an Error in Calculate Dimension).

Could anybody help me in this trouble, pls?

N.

[jwjackso]

Try adding the Aggr function around your IF statement.

Aggr(If (GanttDate>=Min(DeliveryDate), OrderNumber, Null()),GanttDate)

[NickP_DF]

Hello,

thank you for the replay: I'm sorry but your suggestion doesn't work 😞

Since the statement "If GanttDate>=Today(), OrderNumber, Null())" works properly, I thought that a fixed value is necessary instead of a row-by-row calculated one, so a possible workaround should be to get the minimum possible value of the Delivery date by extracting it from the selection parameters, but unfortunately the GetPossibleCount(DeliveryDate) exists and the GetPossibleValue(DeliveryDate)  does not.

Do you thing it should be a possible way to explore?

Thanks.

[Kushal_Chawda · Accepted solution]

try below

Aggr(If (GanttDate>=Min(DeliveryDate), OrderNumber, Null()),GanttDate,OrderNumber)

or

Aggr(If (GanttDate>=Min(DeliveryDate), OrderNumber, Null()),OrderNumber)

[NickP_DF]

The first one works very well!

Thank you so much!

N.