Calculated field with different dataset

Question & Answer
,
1

I have a set of gross sales data in my analysis, and I have another set of renegotiations data. I would like to make a calculated field with the sum of the total value column from the gross sales dataset minus the sum of the total value column from the renegotiations dataset. How can I do that?

In other words: “totalsalesvalue”(gross sales dataset) - “total renegotiationvalue”(renegotiations)

Thank you already!

1 Like
2

Hi @DeividO,

You can’t create a calculated field using fields from different datasets. You’ll have to join the 2 datasets and then use the resulting dataset in your analysis.

1 Like
3

Hi @DeividO,
It’s been awhile since we last heard from you, did you have any additional questions regarding your post?

If we do not hear back within the next 3 business days, I’ll close out this topic.

Thank you!

4

Hi @DeividO,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community and link this discussion for relevant information if needed.

Thank you!