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
Solved! Go to Solution.
<<IF(
[Code]="Other",
[OTHER],
""
)>>
<<IF(
OR(
[Code]="Other",
[Code]="New"
),
[OTHER],
""
)>>
or
<<IF(
IN(
[Code],
LIST("Other", "New")
),
[OTHER],
""
)>>
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โ))>><<End>>
|
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>>
<<IF(
[Code]="Other",
[OTHER],
""
)>>
Thanks guys, this works great....
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
Good one. @SkrOYC , that is much better. ๐
User | Count |
---|---|
26 | |
25 | |
25 | |
22 | |
22 |