17 Replies Latest reply: Mar 18, 2016 11:47 AM by Edgar Lensing RSS

    Set expression in Min() leads to '-'

    Edgar Lensing

      I have a test-table with one dimension:

       

      product_id

       

      I have the measure Min(price)

      to check whether  there is data or not.

      I have a min price for each product_id, so do I if i select the last date by myself.

       

      But if i try to use a set expression to ensure that the min price shows the data for the last date, i only have "-" signs in the column.

      Min({ $ <filter_date = {'$(=date(floor(Max( {$<[filter_date]=>} discoverydate))))'} price)

       

      I checked the inner

      =date(floor(Max( {$<[filter_date]=>} discoverydate)))

      too, and it has the intended date which i want to use as filter_date.


      any ideas?