Skip to Content
1
Nov 30, 2021 at 02:42 PM

Too many member combination in Data Action - SAC

1051 Views

Hello,

I have a DA that used to work properly - but after the last SAC update it doesn't any more:

I have an "IF" with different formula depending on an account (ZFP_ACC) defining my gross sales as quantities multiply by price.

see hereby the error I get is about "Too many member combination" when I tried to delete memberset it didn't help.

if.png

as I said it worked perfectly in the past and now I cannot validate it

Thank you

Deb

 

VARIABLEMEMBER #GGSALES OF [d/ZFP_ACC] IF RESULTLOOKUP([d/ZFP_ACC] = "GROSS_SALES_INT") = NULL THEN DATA([d/ZFP_ACC]= #GGSALES) = RESULTLOOKUP([d/ZFP_ACC] =#NETQTY) * RESULTLOOKUP([d/ZFP_ACC] ="GRSS_PRC") ELSE DATA([d/ZFP_ACC]= #GGSALES) = RESULTLOOKUP([d/ZFP_ACC] = "GROSS_SALES_INT") ENDIF

Attachments

if.png (56.3 kB)