Fabric Plan Community Logo
Sign in

Earnings Per Share is coming up all Zeros... Please help me if you can.

Started by ScottStauffer · 1 week, 3 days ago · 2 replies · 88 views
ScottStauffer Participant
1 week, 3 days ago

I seem to be stuck in the rough again.  Again, likely just me... but I create this formula and it has 0's for the results.
Maybe I need to take a break and look with fresh eyes, but I looked in the PDF steps and watched the video.

Fabric Planning Hands-on Labs: 10 Guided Exercises

Exercise #9 - Build a P&L in the Intelligence Sheet

E9 - Build a P&L in the Intelligence Sheet Guide

7. Insert a Calculated Row: Earnings Per Share

Select Insert Row > Calculated Row.

Name the row “Earnings Per Share” and enter the formula: Revenue / Shares Outstanding and click
Create.

Page 5 & 6  of 137

I watch the accompanying video Intelligence E9 Labs Walkthrough | Videos & Movies on Vimeo

at 2:47 of the video I create the calculation and get 0's in both columns, unlike what the video shows.  Is anyone else getting the same results.  Am I making a common mistake?
in the video the presenter had EPS as $35.29 for Plan and Actuals as $53.66 in Millions... me 0.00 and 0.00

Any thoughts would be much appreciated!

Up
0
2 Replies
Logeshkumar
BI Engineer · Lumel Technologies · 1 week, 3 days ago

Hi ScottStauffer,

When the calculated row is created, the number formatting may be automatically set to Auto, even if None was selected during row creation. This can cause the result to display as 0.00.

Please select the Earnings Per Share row and change the formatting from Auto to None from the Matrix ribbon. Once the formatting is updated, the calculated values should display correctly instead of showing zeros.

We have identified this issue and a fix is planned for an upcoming release to ensure the selected formatting is retained when creating calculated rows.

Sorry for the inconvenience! Please let us know if you continue to experience the issue. We're happy to help.

Up
0
ScottStauffer
Principal Consultant · Improving · 1 week, 3 days ago

Thanks, Logeshkumar - I appreciate that you provided the update.  I will give it another go!

Up
0

Viewing 2 replies - 1 through 2 (of 2 total)

  • The topic ‘Earnings Per Share is coming up all Zeros... Please help me if you can.’ is closed to new replies.
Fabric Plan
Enterprise planning, integrated with PowerTable and Intelligence, native to Microsoft Fabric. Co-engineered with Lumel.
BUILT ON MICROSOFT FABRIC
CERTIFIED BY
Fabric Planning is certified by IBCS
Microsoft, Azure, Copilot, Excel, Fabric IQ, Microsoft Entra, Microsoft Fabric, Microsoft Teams, OneLake, Outlook, Power Automate, Power BI and SharePoint are trademarks of the Microsoft group of companies. IBCS is a registered trademark of IBCS Association. All other trademarks are the property of their respective owners.

This community is operated independently by Lumel. Nothing on this site constitutes a representation or warranty by Microsoft.