4 Replies Latest reply: Apr 2, 2014 11:59 AM by Richard Pearce RSS

    calculated dimension if and

      Why this works for a field in a listbox and not for a calculated dimmension in a pivot table

       

      =if(left(conta_id,2)='92'and Len(conta_id)=4,conta_id)

       

      thank you for your time