Show item cost in word template

[DaveWillett]

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

[SkrOYC · Accepted solution]

<<IF(
  [Code]="Other",
  [OTHER],
  ""
)>>

[Suvrutt_Gurjar]

You could try in the SELECT(Ticksheet[Other].......) expression [_THISROW].[Code] ="Other" instead of just [Code]="Other"

[DaveWillett]

Hi Suvrutt, something isn't right, I'm not getting the report at all with:

<< SELECT(Ticksheet[OTHER] ,  AND([JobID]=[_THISROW].[Code]=”OTHER”))>><<End>>

[Suvrutt_Gurjar]

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” ))>>

<<End>>

[SkrOYC · Accepted solution]

<<IF(
  [Code]="Other",
  [OTHER],
  ""
)>>

[DaveWillett]

Thanks guys, this works great....

[SkrOYC]

Your totals seem wrong if someone doesn't know where that data comes from

[DaveWillett]

Hi. This was test data but all totals are now returning correct. Thanks for pointing out.

[DaveWillett]

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],""))

[SkrOYC · Accepted solution]

<<IF(
  OR(
    [Code]="Other",
    [Code]="New"
  ),
  [OTHER],
  ""
)>>

or

<<IF(
  IN(
    [Code],
    LIST("Other", "New")
  ),
  [OTHER],
  ""
)>>

[DaveWillett]

Brilliant Thanks

[Suvrutt_Gurjar]

Good one. @SkrOYC , that is much better. 👍