Skip to content
TheChatArchiveThe Chat Archive
gpt-3.5-turbo-0613· OpenAIAi2 WildChat-4.8M (AI2)

Fix the error A function 'PLACEHOLDER' has been used in a True/False expression that is…

  1. User

    Fix the error A function 'PLACEHOLDER' has been used in a True/False expression that is used as a table filter expression. This is not allowed.

    Promo Vol, TOP N = CALCULATE(SUM('Share16вед'[Отгрузка по акции, л.]), [Is Selected Product Rank] = 1)

  2. Assistant

    To fix the error, you need to remove the invalid function 'PLACEHOLDER' and use a valid expression in the table filter instead. Here's an updated version of the expression:

    Promo Vol, TOP N = CALCULATE( SUM('Share16вед'[Отгрузка по акции, л.]), 'Share16вед'[Is Selected Product Rank] = 1 )

  3. User

    Promo Vol, TOP N = CALCULATE(SUM('Share16вед'[Отгрузка по акции, л.]), 'Customer_SKU_Share_Month'[Is Selected Product Rank] = 1)

    The error is still available

  4. Assistant

    Apologies for the confusion. The error may be due to the fact that the 'Customer_SKU_Share_Month' table does not have a column named 'Is Selected Product Rank'. To fix the error, you should check your data model and ensure that the column name is correct. Here's the updated expression to use if the column name is correct:

    Promo Vol, TOP N = CALCULATE( SUM('Share16вед'[Отгрузка по акции, л.]), 'Share16вед'[Is Selected Product Rank] = 1 )