3 Replies Latest reply: Nov 10, 2011 7:34 AM by Sunil Chauhan RSS

    Set Analysis Error

      Hi All

       

      Getting error in expression.

      Job Number and Sales Order Number has 1:1 relation and same no. For ex: If Job No = 1234 then Sales Order No = 1234

      I want to link data so that I can get Invoice Amount details at Job No level.

       

      Dimension = Job Number

      I tried below expression but this gives error:

      sum({<[Sales Order Num]={[Job Number]}>}[Invoice Amount])

       

      Can someone help pl?