Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I was wondering if it is possible to get the minimum and the maximum possible value in a specific field (in which no selections have been made), based on applied filters on other fields.
Attached an example. The goal is to obtain the value 2014/03/01 for min and 2014/10/01 for max.
I tried with FieldValue, but that did not work as expected.
e.g. ='Lowest possible date value: ' &min(FieldValue(Date,1))
All suggestions are welcome!
Regards,
Maarten
Hi,
the problem was, that Date was not a Date value.
Take a look an the script. Now Date is a Dual value so you can use the Max/Min function
Hi,
the problem was, that Date was not a Date value.
Take a look an the script. Now Date is a Dual value so you can use the Max/Min function
Hi Maarten,
see attached version using a "real Calendar", works as expected with min and max
Regards
Andy
Dear Sebastian,
Dear Andrew,
Thanks a lot! Didn't guess it was that simple... but seems indeed to solve the problem.
At a certain point one is no longer taking a look at the basics... . Luckily your focus was still very sharp
Have a nice day!
Maarten
No Problem,
it's very easy to make things too complicated and miss the obvious !
You have a good day too!
Regards
Andy