OAC - BI: Custom Numeric Formatting

At a Client we had a use case to show values in pivots and tables scaled to Thousands and Millions.

Instead of dividing by 1,000 or 1,000,000 my client looked into format masking.

Here is what he came up with and I thought I would share