Power Platform
Dynamics  CRM

Tip of the Day

1462 tips served

Tip #1449: Formula columns love calculated columns

A digitally created image featuring a knight in full armor at dusk, holding a large shield designed to resemble a giant calculator with an illuminated display. The knight is poised for battle with a sword in the right hand. In the extended background, a dramatic and cloudy sky looms over a chaotic medieval battlefield scene, with silhouettes of other knights engaged in combat and fallen warriors scattered across the field, enhancing the surreal fusion of ancient warfare and modern technology.

Can’t return the data type you need from a formula column? Do your homework then create a calculated column that simply casts to the correct type.

Posted on March 8, 2024 by George Doubinski (Twitter) in Dataverse, Development
Tagged choice, currency, formula columns, limitations, power fx, whole number
  • BAD Masterclass
  • The Crew
  • Power Automate Reference Guide
  • The Tip (of the iceberg)
  • The Feed
Got a tip? Send it to the jar!

 

Follow @crmtipoftheday

Recent Tips

  • Tip #1462: How to mirror iPhone to Windows
  • Tip #1461: Big int data type is available in Dataverse
  • Tip #1460: Loops and ThisRecord in low-code plug-ins

Categories

  • Access Teams (1)
  • Activity Management (5)
  • Administration (178)
  • Adoption (24)
  • AI (3)
  • Alternative uses (2)
  • App Designer (4)
  • AppSource (2)
  • Attachments (2)
  • Audit (2)
  • Azure (7)
  • Case Management (7)
  • Charts (9)
  • Configuration (31)
  • CRM 2011 (57)
  • CRM 2013 (201)
  • CRM 2015 (121)
  • CRM 2016 (74)
  • CRM for Outlook (49)
  • CRM for Tablets (33)
  • CRM Online (149)
  • Customer Service (24)
  • Customization (177)
  • Dashboard (1)
  • Dataverse (45)
  • Deployment (78)
  • Development (184)
  • Document Management (8)
  • Documentation (18)
  • Dynamics 365 (235)
  • Excel (10)
  • Exchange Synchronization (19)
  • Field Service (7)
  • Gamification (4)
  • Goals (1)
  • Installation (12)
  • Integration (7)
  • Knowledge Base (4)
  • Learning (5)
  • Mail merge (1)
  • Marketing (24)
  • Metadata (2)
  • Microsoft Teams (1)
  • Mobile (50)
  • Offline (3)
  • On-Premises (17)
  • Outlook (28)
  • Performance (22)
  • Power Apps (52)
  • Power Automate (102)
  • Power BI (10)
  • Power Pages (44)
  • Power Platform (7)
  • Processes (8)
  • Queues (6)
  • Relationships (5)
  • Reporting & Charts (36)
  • Sales (17)
  • Security (82)
  • SharePoint (13)
  • Shorts (1)
  • Social (3)
  • Solutions (16)
  • SP1 (19)
  • Stargazing (41)
  • TIL (7)
  • Truckstop (49)
  • Uncategorized (2)
  • Unified Interface (20)
  • Upgrades (5)
  • Usability (122)
  • Utilities (4)
  • UUI (4)
  • Video (92)
  • Views (8)
  • Voice of the customer (10)
  • Workflow (71)
May 2025
M T W T F S S
 1234
567891011
12131415161718
19202122232425
262728293031  
« Jun    
Copyright © Power Platform & Dynamics CRM Tip Of The Day 2025. WordPress theme by Ryan Hellyer.