Forum Discussion

WelterM's avatar
WelterM
Helper I
8 years ago

NaN error in Matrix in Desktop

I have added a new column to a table with the following formula:   Stages Progressed Last 30D Raw = if('Contact Progress Log'[Log_Date__c] >= TODAY()-30, ('Contact Progress Log'[Status] - 'Contact ...
WelterM's avatar
WelterM
Helper I
8 years ago

Both of those are numeric fields.

RamySaroufim's avatar
RamySaroufim
Microsoft Employee
8 years ago

Are they both Integer? Double?

  • WelterM's avatar
    WelterM
    Helper I
    8 years ago

    They are both calculated columns. The calculations are the same for both, with the exception of the column they access:

     

    Previous Status = VALUE(LEFT('Contact Progress Log'[Previous_Status__c], 1))