Steve Ennis 2 Posted May 28, 2019 Share Posted May 28, 2019 Metres Drilled / Days to Drill is what I am trying to accomplish. Strangely the data types are Currency(I don't know why) /TimeSpan I have tried to change the currency but can not. The same with the Time Span as it is the subtraction of two dates. Link to comment Share on other sites More sharing options...
Steve Ennis 2 Posted May 28, 2019 Author Share Posted May 28, 2019 I also think I may have some nulls to deal with. I think this may be why my formula may be failing.... Link to comment Share on other sites More sharing options...
Gaia Paolini Posted May 29, 2019 Share Posted May 29, 2019 A sample of the data within your Spotfire dxp file would help understand what you are experiencing (data types, nulls, formula...). Please take a look at this: https://community.spotfire.com/wiki/quick-tips-asking-community-questions Gaia Link to comment Share on other sites More sharing options...
Gaia Paolini Posted May 29, 2019 Share Posted May 29, 2019 A TimeSpan is not a number so you cannot divide by it. If you surround it by Days(..) you get a number (of days). Gaia 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