cancel
Showing results for 
Search instead for 
Did you mean: 

Multivalue + Min function

Former Member
0 Kudos

Hi Gurus,

I would like to ask you for your help. I have three columns - ID number, date and days.

I want to display each specific ID number with "Min" value of the days in one row without Multivalue error.

I tried =Min([days]) In ([ID Number]) but it's not working.

former_member199945
Active Contributor
0 Kudos

Hi,

Convert Days object as Dimension Object and create new formula on top of this dim object .

Thanks

Accepted Solutions (0)

Answers (1)

Answers (1)

former_member198519
Active Contributor
0 Kudos

Try this:

= Min([days]) ForEach ([ID Number])

Former Member
0 Kudos

Hello Kuldeep,

Thanks for your answer. I tried this too, but it shows multivalue error

former_member198519
Active Contributor
0 Kudos

I tried the same as well

capture.png