Jump to content
We've recently updated our Privacy Statement, available here. ×

How to multiply two separate columns with the same timestamp in different rows


Noah Holihan

Recommended Posts

Hi all,

I'm having an issue trying to calculate this in Spotfire, where it would be extremely easy in excel. I have a data set that is imported from a source and automatically sets it in a table like the following:

 

 

 

Timestamp

Column A

Column B

 

 

1/1/2019

100

 

 

 

2/1/2019

200

 

 

 

3/1/2019

150

 

 

 

1/1/2019

 

1

 

 

2/1/2019

 

0

 

 

3/1/2019

 

1

 

 

 

In another column I want to have column A multiplied by column B for each of their respective timestamps. For instance, the first row would be 100 * 1, as they bot hcorrelate to 1/1/2019. Any information on this would be great, thanks!

Link to comment
Share on other sites

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...