Invalid dimension error - slider

[Zeny]

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

[Zeny]

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

[joaopaulo_delco]

Hi @Zeny 

Try this

if (sum(Percent) >= $(vMinPercentage) and sum(Percent) <= $(vMaxPercentage), sum(Percent), null())

[Zeny]

Hi @joaopaulo_delco

Thanks your reply, unfortunately it still throwing the same error