If expressions in templates

[LeviP]

Hello guys, 

I am trying to print the 4 barcode codes of the product, but only if printing is enabled in the client table, I have it this way but it does not print

I am trying to print the last 4 barcode codes of the product, but only if printing is enabled in the customer table, I have it this way but it does not print

<<Start: [Related InvoiceDetails]>><<[ProductID].[Producto]>><<If:([CustomerID].[PrintCodBarra]=Si)>>
<<RIGHT[ProductID],4>>
<<EndIf>>
<<[Quantity]>>
<<[Price]>>
<<[Total]>><<End>>

where the formula is wrong

[dbaum]

---

@LeviP wrote:

[CustomerID].[PrintCodBarra]=Si

---

If PrintCodBarra is a Yes/No type column, confirm whether this syntax works elsewhere in your app. If it doesn't, consider revising Si to Y or true or even just eliminating =Si. If it's a Text type column, try enclosing Si in quotes: "Si".

---

@LeviP wrote:

RIGHT[ProductID],4

---

Try RIGHT([ProductID],4).

[LeviP]

Yes/No, I have it as Si/No in Spanish

[LeviP]

This way works very well, however I need the condition of the Customer.PrintCodBarra table (Yes/No) so that it prints if it is true
<<Start: [Related InvoiceDetails]>><<[ProductID].[Producto]>>
<<RIGHT([ProductID],4)>>

At some point I am writing the condition wrong or I am not applying the correct logic

[LeviP]

And in this way it doesn't work, it doesn't even generate the pdf

[LeviP · Accepted solution]

It is already solved, the detail is that it does not have a reference in the detail of the invoice, only in the header, that is why the formula was changed
ANY(SELECT(Customers[PrintCodBarra]