Hello,
I need to use more Catalog/Category on same analysis and I wondering to use a filter in the column formula.
Example: Catalog Code: Intrastat. Under this Catalog I have many category codes.
I have many other Catalog/category values that I want to put on a different column, that is why I cannot add a simple filter.
Example that I wanted to add in the formula:
FILTER("Category"."Category Code" USING ("Catalog"."Catalog Code" = 'INTRASTAT')
Error that I am getting:
Formula syntax is invalid.
[nQSError: 10058] A general error has occurred. (HY000)
[nQSError: 43113] Message returned from OBIS. (HY000)
[nQSError: 27002] Near : Syntax error (HY000)
[nQSError: 26012] . (HY000)
SQL Issued: SELECT FILTER("Category"."Category Code" USING ("Catalog"."Catalog Code" = 'INTRASTAT') FROM "Product Management - Components Real Time"
OK (Ignore Error)
Thanks in advance for your help!
Antal