on 07-24-2017 3:31 PM
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
Convert Days object as Dimension Object and create new formula on top of this dim object .
Thanks
Try this:
= Min([days]) ForEach ([ID Number])
Hello Kuldeep,
Thanks for your answer. I tried this too, but it shows multivalue error
I tried the same as well
capture.png
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.