Hi,

You most probably need to use a countunique modifier instead of the COUNTUNIQUEOF function.

Maybe try something like this:

IF(Month < 'Switchover Date for Forecast/Budget',IF('Full data BI'.subscription_type = 'Subscription Type'."Renewable" AND 'Full data BI'.segment_revenue_category <> 'Customer Category'."Churn",

'Full data BI'.customerid  by countunique :'Full data BI'.segment, 'Full data BI'.segment_revenue_category,'Full data BI'.Month, 'Full data BI'.customer_type, 'Full data BI'.product, 'Full data BI'.product_type, 'Full data BI'.region, 'Full data BI'.subscription_type]))

 

Hope this helps!

Best,

 

Hello, formula seems to be working but i have this error message : 

The formula reached 201 G cells during one of its execution steps, exceeding the maximum size allowed (1 G)

I have 450k lines in my database, do you think it could be due to its size ? 

Thanks again for your help !!

 

 

Can you maybe try this in the formula playground in auto mode:

 

IF(Month < 'Switchover Date for Forecast/Budget',

'Full data BI'.customerid

>filter: 'Full data BI'.subscription_type = 'Subscription Type'."Renewable"]

/exclude: 'Full data BI'.segment_revenue_category = 'Customer Category'."Churn"]

dby countunique :'Full data BI'.segment, 'Full data BI'.segment_revenue_category,'Full data BI'.Month, 'Full data BI'.customer_type, 'Full data BI'.product, 'Full data BI'.product_type, 'Full data BI'.region ]))

 

Please let me know.

Thanks