Forum Discussion

azaterol's avatar
azaterol
Helper V
4 years ago
Solved

Fill with digits

Hello everyone, I have a table "Customers_and_Suppliers" that contains an ID and the corresponding Customers_and_Suppliers_NR. I want to add a  custom column in this table. If there is a NR that mat...
Need Help
  • tamerj1's avatar
    tamerj1
    4 years ago

    Ho azaterol 

    you can try

    IF ( Table1[Customers_and_Suppliers_NR] IN VALUES ( Supplier[ID], 20000000000, 10000000000  ) + VALUE ( Table1[ID] ), 

tamerj1's avatar
tamerj1
Community Champion
4 years ago

Ho azaterol 

you can try

IF ( Table1[Customers_and_Suppliers_NR] IN VALUES ( Supplier[ID], 20000000000, 10000000000  ) + VALUE ( Table1[ID] ), 

  • azaterol's avatar
    azaterol
    Helper V
    4 years ago

    tamerj1  works fantastic! Can you explain how this work? 

    • tamerj1's avatar
      tamerj1
      Community Champion
      4 years ago

      azaterol 

      It is just exactly as you read it. If the NR is in the supplier ID table then 20000000000 otherwise 10000000000 then add this number to the numeric value id table1[ID]