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

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!

(1) Answer

Login