Hi Nancy,
Without looking at your formula, it’s hard to say. Maybe your formula is trying to calculate on too many cells?
Have a look at this article that may help you or try avoiding to use densifying functions like ISBLANK.

Hope this helps!

I am also facing the similar issue,
Getting the error: “Maximum cardinality exceeded (3,460,343,100 > 1,000,000,000)”
(IF(('Relocated?'),'Goal Value',0))
If relocated is true, then return goal value, else 0.
Source Metric and target metric are having dimensions: Employees, projects, integers 

Can anyone please let me know how to resolve the cardinality issue?
 

Hi @pigment_enthusiast ,

You can avoid the 0 in the second argument as it is not needed to set a second argument in the IF statement:
IF('Relocated?','Goal Value'), this will result in blanks instead of zeros which will help you avoid the Maximum Cardinality error and take advantage of Pigment sparsity.
here is the article as well to understand how pigment handles sparsity.

Hope this helps 

It has resolved now, thanks @Issam Moalla .
 
I have another metric wherein i have the formula, Getting cardinality issue.
IF('Position' <> 1 AND (ISBLANK('Not Relocated?') OR ('Not Relocated?' = FALSE)),TRUE)