natural_cg
New Member
- Joined
- Jul 19, 2014
- Messages
- 4
I have 2 tables. Relationship is made on campaignID
Table 1 - Clicks
- clickID
- campaignID
- count of clickID
- other_stuff
Table 2 - Campaigns
- campaignID
- campaign_name
- campaign_cpc
I created a calculated field on the clicks table to count clickID (get the number of "views").
However when i try to create a calculated field formula:
<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; background: rgb(238, 238, 238);">
=Clicks[count of clickID]*Campaigns[campaign_cpc]</code>
I get an error. Is says it needs a relationship. More specifically:
"The value for column 'campaign_cpc' in table 'Campaigns' cannot be determined in the current context"
I already tried using the RELATED() function but it still doesn't work. I get the same error. I've been at this problem for the past day and would appreciate some guidance.
Thanks
Table 1 - Clicks
- clickID
- campaignID
- count of clickID
- other_stuff
Table 2 - Campaigns
- campaignID
- campaign_name
- campaign_cpc
I created a calculated field on the clicks table to count clickID (get the number of "views").
However when i try to create a calculated field formula:
<code style="margin: 0px; padding: 1px 5px; border: 0px; vertical-align: baseline; font-family: Consolas, Menlo, Monaco, 'Lucida Console', 'Liberation Mono', 'DejaVu Sans Mono', 'Bitstream Vera Sans Mono', 'Courier New', monospace, serif; white-space: pre-wrap; background: rgb(238, 238, 238);">
=Clicks[count of clickID]*Campaigns[campaign_cpc]</code>
I get an error. Is says it needs a relationship. More specifically:
"The value for column 'campaign_cpc' in table 'Campaigns' cannot be determined in the current context"
I already tried using the RELATED() function but it still doesn't work. I get the same error. I've been at this problem for the past day and would appreciate some guidance.
Thanks