RGranada Contributor 
-
Re: HTML in Summary Number
Beware of using concat's in summary numbers if you want them later to be imported by Powerpoint Plugin. It doesn't import summary numbers originated in concats.2 -
Re: Sort Table by Field Count
Ok , So, I think that in a datatable you will only have the aggregation enabled in the sorting section if there is at least one aggregated field (with a calculation other then no aggregation) (even t…1 -
Re: Calculation of weekdays (Saturday-Friday)
Hi, The following Beast Mode will give you the week number (weeks starting on Saturday) for a given date: MOD(FLOOR((DATEDIFF(your_date_field,'2006-01-01' )-6)/7),52)+1 Tell me how it went.…1 -
Re: Unable to Convert to a Date and Time Format
Ok forgot that... Yes, you can split all your columns as you need in Magic ETL, leave the dates in the fields as they are, then use a MySql Dataflow to convert the dates, use output dataset of your m…1 -
Re: Custom Summary Number using Beast Mode with Thousands Separators
Hi, I think the following beast mode will do the trick: CASE WHEN Length(CONCAT(ABS(ROUND(Your_Field_Name,0)),'')) = 9 THEN CONCAT(SUBSTRING(CONCAT(Round((ABS(Your_Field_Name)),0),'�…1
