jbuaron

Comments

same inquiry here - we align to Fiscal Calendar so would be great to know how it can be done in DOMO

in Fiscal calendar in Beast Mode Comment by jbuaron May 2017
@AS removing the space is tricky lol - took me awhile and by just entering a blank value (space) solved it! thanks

in Changing text value to whole number value Comment by jbuaron May 2017
thanks for the speedy response and that able to eliminate the USD. However, when I use now the Set Column Type, seems I am getting similar error -- please find attached screenshot. Any idea how I can move forward? Thank you in advance.

in Changing text value to whole number value Comment by jbuaron May 2017
tried RIGHT(`Forecasted/Actual Churn Value`,2)*1 or SUM(REPLACE(`ACV Amount at Risk`,',','')) and both not working on my end or Im doing wrong. The RIGHT commands output something but wrong value - meaning to small on the real $ value while the SUM command is not outputting anything at all. Please find the attached…

in Convert text into a number Comment by jbuaron May 2017
feels same issue here. I am getting "Failed to convert data 'USD 440,000' to type Integer for column 'ACV Amount at Risk' when on Magic Etl. Basically, I wanted to convert that field that is Text into a Number so I can report the $ value. Very new in DOMO so not finding ways to get this use case resolve :(

in Changing text value to whole number value Comment by jbuaron May 2017