We have a metric that we track regarding logins, and we want it to show as blank or null if there are no active users yet because technically they could have a 0% login rate with active users which is different than 0% with no active users. I’m trying to create a calculated field on the company object.
I’ve tried many different versions. All so far will show 0% even when there are no active users. I’ve tried =null, is not null, =0, ...
case when Active_Users is null then null else Unique_Login / Active_Users end
Best answer by phani_kumarView original