I have a string field that contains a dollar figure of total cost. It is a string field but I need it to be numeric so that I can use aggregate functions. I am having trouble converting the field from string to numeric. So far I am able to format the...

I have a field in my database that is a string field but it contains dates in the following format: “yyyy-mm-dd” - I need to convert this string into a date dimension so that I can use it in calculations. All of my attempts are not working. My field ...