arrow-icon-size3 Contact Us

Today is Special!

Today (2025-04-01) the rules of mathematics no longer apply!
The right brain’s creativity has officially outwitted the left brain’s logic.

 

If we take today’s date and break it into day, month and year, then aggregate each segment’s digits we get:

Day: 0 + 1   = 1

Month: 0 + 4   = 4

Year: 2+0+2+5 = 9

If we take the square root of each of these we get:

√1 = 1

√4 = 2

√9 = 3

So far, so good – three nice clean numbers: 1, 2, 3.

Naturally,  (3 ÷ x) should equal (1 ÷ x) + (2 ÷ x)

As we all learned in school, it should, not matter how we change X, as long as we apply it consistently, our equation should balance.

Let’s use MDX code test this by creating a fourth value for X, using today’s date to derive a common denominator and see if our left brain logic still agrees with right brain creativity.

				
					WITH  
   MEMBER [}Clients].[}Clients].[Result] AS NULL, SOLVE_ORDER = 1
   MEMBER [}Groups].[}Groups].[One]   AS 1,  SOLVE_ORDER = 2
   MEMBER [}Groups].[}Groups].[Two]   AS 2 , SOLVE_ORDER = 3
   MEMBER [}Groups].[}Groups].[Three] AS 3 , SOLVE_ORDER = 4
   MEMBER [}Groups].[}Groups].[X]     AS 3 + 1/Power(2025 * 4 * 1, 2) /10E-17, SOLVE_ORDER = 5
   
   MEMBER [}Groups].[}Groups].[Right Brain Value] AS 
         [}Groups].[}Groups].[One] / [}Groups].[}Groups].[X] + 
         [}Groups].[}Groups].[Two] / [}Groups].[}Groups].[X], SOLVE_ORDER=6
   
   MEMBER [}Groups].[}Groups].[Left Brain Value] AS 
         [}Groups].[}Groups].[Three] / [}Groups].[}Groups].[X], SOLVE_ORDER=7
   
   MEMBER [}Groups].[}Groups].[State] AS 
         IIF(
            [}Groups].[}Groups].[Left Brain Value] > [}Groups].[}Groups].[Right Brain Value],
            "Today is special! 3 is greater than the sum of 1 + 2!!", 
            "A normal day where universal rules apply"
         ), SOLVE_ORDER=8
   
SELECT 
   { [}Groups].[}Groups].[State] } ON COLUMNS, 
   { [}Clients].[}Clients].[Result] } ON ROWS 
FROM [}ClientGroups]

 

If we change the date in the denominator to another date e.g. 2025 * 4 * 30 everything is normal:

 

If you don’t believe me try it for yourself. Create a new view using the }ClientGroups control cube. Open up the MDX editor, paste the code in and change the date yourself. Apply the MDX to get your confirmation.

Best to pack everything in for the day and come back tomorrow when the rules of mathematics have normalised again!

 

By George Tonkin, Business Partner at MCi.

Further Reading

Tagged