GrantSmith Coach 
-
Re: error while converting text to integer/float
You can feed it into a regular expression in a formula tile to convert () to a negative number with something like this: REGEXP_REPLACE(`field`, '\(\d+\)', '-$1')1 -
Re: Column Order of Dataset
You can use a Select Column tile to set the ordering of your columns in your output dataset.1 -
Re: Variable fomat
Change Type of Values from Number to Text1 -
Re: Issue in total/subtotal of the pivot
This is because how your Beast Mode is written, it aggregates everything first and then just subtracts an hour. What you'll want is (assuming you're filtering for records where the duration is alread…1 -
Re: Beast mode to remove "double quotes"?
You should be able to just use the REPLACE function like you mentioned: REPLACE(`Client Name`, '"', '.') How is your beast mode not working? What are you getting and what are you expecting?1
