3 Replies Latest reply: Aug 15, 2017 5:28 PM by Oleg Troyansky RSS

    Set Analysis expression using Left function

    Cliff Clayman

      I am trying to get this expression working using Set Analysis because it renders very slowly if I write it as an If expression.  I can't figure out what the proper syntax is for using the Left function.

       

      sum({<[Period] = {'P1'},[Vendor Type] = {'3PL'}, left([Aging],1)={'d'}>} [LineItems])

       

      left([Aging],1)={'d'} - this is what is not working