Skip to Content
0

Multivalue + Min function

Jul 24, 2017 at 02:31 PM

30

avatar image
Former Member

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.

cc.jpg (40.5 kB)
10 |10000 characters needed characters left characters exceeded

Hi,

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

Thanks

0
* Please Login or Register to Answer, Follow or Comment.

1 Answer

Kuldeep Ghosh Jul 24, 2017 at 02:47 PM
0

Try this:

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

Show 2 Share
10 |10000 characters needed characters left characters exceeded
Former Member

Hello Kuldeep,

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

cc2.jpg (57.0 kB)
0

I tried the same as well

capture.png

capture.png (30.3 kB)
0