Hi
I am trying to create a formula in a report that will allow me to categorise the number of Users who have not logged
IF(
TODAY() - DATEVALUE(user.Last_Login) > 30,
"No Login >30 Days",
"Logged In ≤30 Days"
)
However, I get this error - Warning
Error when encoding row-level formula: Field user.LAST_LOGIN does not exist. Check spelling.
I don't understand as I selected it from a drop down option
I don't understand why I am receiving this error.
I want to create a report so that I can display in a dashboard - % users not logged into SF in the past month
#Formulas
Hi
I am working on it right now and I've got it to work - using this reference, but thank you for taking time to review
How to Calculate the Number Days that User Logged in Using Last Login API Name - ServiceMax Knowledge
Number of Days since last login= (NOW() - LAST_LOGIN)
Login Status = IF(NOW() - LAST_LOGIN > 30,
"Not Logged In for more than a Month",
"Logged In - Active Users"
)
Able to show 30% of Users are not actively using SF
