Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
this should work:
sum({<[Sales Order Num]=P([Job Number])>} [Invoice Amount])
I tried above expression but its not working.
Any alternative?
use this
sum({<[Sales Order Num]={$(=[Job Number])}>}[Invoice Amount])
hope this help