Skip to main content
Topics#Reports & DashboardsBrian LaRue's Question
Brian LaRue asked in #Reports & Dashboards
Apr 23, 2021, 5:14 PM

May a BLANKVALUE check a number but return text if blank?

I have a row-level formula on a report on Users that calculates the number of days since last log-in. I want to display text if the calculation is null or blank. The forumla is currently:

 

BLANKVALUE(TODAY() - DATEVALUE(LAST_LOGIN),"Never")

 

The report displays users that have never logged-in as '-' and users that have logged-in today as a '0'. 

 

I would like it to say "Never" instead of the dash. Can you not mix datatypes? I can convert all numbers to TEXT() but am afraid that would complicate the sorting 

 

1

 

10

 

2

 

20

 

Is there anyway to solve this?
1 answer
  1. Tony Trinh
    Apr 23, 2021, 5:29 PM
    Hi Brian,

     

    You are correct. You cannot have varying data types for a single field. You can, try to pad with leading zeros to address the sorting order. It doesn't look as aesthetically please, but it will at least address it.

    BLANKVALUE(LPAD(TEXT(TODAY() - DATEVALUE(LAST_LOGIN)), 2, "0"),"Never")
Write an answer...
0/9000