Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Everyone,
I am using the following expression on one of my dimension in table, and it is throwing an invalid dimension error:
if (sum(Percent) >= vMinPercentage and sum(Percent) <= vMaxPercentage, sum(Percent), null())
I think aggr function should be used, but i don't know how. 😞
Please correct me
Thanks in advance for your help
Hi @Zeny
Try this
if (sum(Percent) >= $(vMinPercentage) and sum(Percent) <= $(vMaxPercentage), sum(Percent), null())