I have a template showing items estimated. Where labour elements are concerned I am not interested in showing, but where an item has a [Code]=“OTHER” I want that items cost to show.
In the above example only the ADAS Calibration should show should show it’s value of £250, currently the £250 is also showing along side the ‘Wing’ with the code ‘NEW’ that should show nothing.
Below is the tepmplate
Can anyone help?
Thanks
You could try in the SELECT(Ticksheet[Other]…) expression [_THISROW].[Code] =“Other” instead of just [Code]=“Other”
Hi Suvrutt, something isn’t right, I’m not getting the report at all with:
<< SELECT(Ticksheet[OTHER] , AND([JobID]=[_THISROW].[Code]=”OTHER”))>><> |
|---|
I had requested you try the below, replacing [Code]=“Other” with [_THISROW].[Code]=”OTHER”
<< SELECT(Ticksheet[OTHER] , AND([JobID]=[_THISROW].[Job ID], [_THISROW].[Code]=”OTHER” ))>>
<>
<<IF(
[Code]="Other",
[OTHER],
""
)>>
Good one. @SkrOYC , that is much better. 
Your totals seem wrong if someone doesn’t know where that data comes from
Hi. This was test data but all totals are now returning correct. Thanks for pointing out.
Can I Tweak this code to also include the code “NEW”?
So I should be able to see any cost against the [CODE] if it shows “OTHER” or “NEW”
Is this correct:
<<IF: AND(([CODE]=“Other”), ([CODE]=“New”),{OTHER],“”))
<<IF(
OR(
[Code]="Other",
[Code]="New"
),
[OTHER],
""
)>>
or
<<IF(
IN(
[Code],
LIST("Other", "New")
),
[OTHER],
""
)>>
Brilliant Thanks