Skip to main content

Hi all.  We are in the process of migrating to Lighting and one of the things we're noticing is how a dashboard table component looks in Classic vs. how it looks in Lightning, specifically to the data.  What I mean is, we have a dashboard with a table component and in Classic it shows certain data that is different than what we're seeing in Lightning.  The other thing I'm seeing is that in Lightning I can't even edit this component.  Attached are screen shots of the same component, in the same environment, but one in Classic and the other in Lightning.  The Members and Groups columns are report formulas that were built a while ago in Classic.  I'm also attaching the actual report formula in Classic to show what we've got going on.  What am I missing here?  Do I need to adjust the decimal places in Classic?  If so, why is it different between Lightning and Classic?  If anyone can shed any light on this or provide some help, I would greatly appreciate it.  Thanks!

13 条评论
  1. 2020年1月22日 17:40

    Unfortunately you're gonna have to create a Formula(Text) field on the object like this

    Datatype = Formula

    Result = Text

    Formula =

    TEXT(YEAR( Effective_Date__c ))

    or

    TEXT(YEAR( Effective_Date__c ))

    +"-"+

    LPAD(TEXT(MONTH( Effective_Date__c )),2,"0")

0/9000