Forum Discussion

admin11's avatar
admin11
Memorable Member
5 years ago
Solved

How to create a column expression to filter certain invoice number ?

Hi All

 

I have below expression working fine :-

_LONG OVERDUE = IF( AR[Customer/Vendor Code] IN { "A10002", "AR10012" }, 0, 1 )
 
I try to convert the above expression to below :-
_LONG OVERDUE INVOICE = IF( AR[AR Invoice Number] IN { "122598" }, 0, 1 )
 
I get error msg below :-
Function 'CONTAINSROW' does not support comparing values of type Text with values of type Integer. Consider using the VALUE or FORMAT function to convert one of the values.
 
My objectives :-
Create a column expression for use for Slicer.
 
Below link is my PBI sameple file :-
 
Paul Yeo
 
Need Help
  • Jihwan_Kim's avatar
    Jihwan_Kim
    5 years ago

    Hi,

    Please try the below.

     

    _LONG OVERDUE INVOICE (JihwanKim) = IF( AR[AR Invoice Number] IN { 122598 }, 0, 1 )
     
    I hope it helps.
    Thank you very much.
     
    Did I answer your question? Mark my post as a solution!

2 Replies

  • Jihwan_Kim's avatar
    Jihwan_Kim
    Super User
    5 years ago

    Hi,

    Please try the below.

     

    _LONG OVERDUE INVOICE (JihwanKim) = IF( AR[AR Invoice Number] IN { 122598 }, 0, 1 )
     
    I hope it helps.
    Thank you very much.
     
    Did I answer your question? Mark my post as a solution!
  • PhilipTreacy's avatar
    PhilipTreacy
    Super User
    5 years ago

    admin11 

    Hi Paul,

    The answer from Jihwan_Kim  is correct.  I just wanted to add why.

    In your original code you were checking for a string (text) becaue you had the Invoice Number in double quotes.

    _LONG OVERDUE INVOICE = IF( AR[AR Invoice Number] IN { "122598" }, 0, 1 )

     

    But the Invoice Number is a number so you have to supply a number to check (don't use double quotes)

    _LONG OVERDUE INVOICE = IF( AR[AR Invoice Number] IN { 122598 }, 0, 1 )

    regards

    Phil