Forum Discussion

lisapduan's avatar
lisapduan
Frequent Visitor
1 year ago
Solved

Help with a Switch formula

I am trying to add a column to a report. The main data for the column is a table called Customers. I have another table called Shifts. I need all occurrances of the User field in Shifts to populate o...
  • lisapduan's avatar
    lisapduan
    1 year ago

    Thank you. I was able to simplify it and got it to work. This is what I ended up with - works great.

     

lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
1 year ago

Both Shifts[UID] and NS_Customer[ID]  columns would need to be of type "Whole Number" for this to work. Alternatively all your tests should have double quotes in them.