Forum Discussion
Creating a calculated column from another table based on date criteria
Example file with Sales and Mailers Tables Example End Product Conversion Chart by Campaign Background: We help boat dealers sell boats, we do marketing for them. I have 2 tables: Mailer table ...
Anonymous attached with this reply.
Anonymous quick question, I think you want to get the campaign id based on store / customer, not only just dealdate
I reviewed this post when I was researching my problem but I think it is off point. I have a string of tables that are related to one another Booking => Order => Division. I am trying to create a calculated column in my Booking table based on something in my Division table. I beleive I need to create two related statements with the lookupvalue statement but am not sure how to do this.