Pooja J Posted September 10, 2020 Share Posted September 10, 2020 Hi, I wanted to calculate $ share value, in excel I use=IFERROR(($M8/$M$6),"") to calculate share. How can I create a calculatedcolumn in Spotfire using the same concept Link to comment Share on other sites More sharing options...
Fabian Duerr Posted September 10, 2020 Share Posted September 10, 2020 It depends where your value 126.1 comes from... If this is just the sum of the 1st column then you simply do... [your.col]/Sum([your.col]) ...and format the column as percentage. If126.1 is a fix value then store it as a doc property and use it in the calculation: [your.col]/${your.doc.prop} Link to comment Share on other sites More sharing options...
Pooja J Posted September 10, 2020 Author Share Posted September 10, 2020 Thank you so much for your comment. Actually, [[$]]] / First([[$]]]) this formula works for me. Thanks, PJ Link to comment Share on other sites More sharing options...
Recommended Posts
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 accountSign in
Already have an account? Sign in here.
Sign In Now