Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am attempting to use this calculation in my dimension but it is not working:
if(sum(total <PROD_DT, REL_CD> VALUE) > 10000000, REL_CD))
What I m trying to do is calculate a sum of 'VALUE' for each 'REL_CD' on a given 'PROD_DT' and only display that 'REL_CD' in the dimension if it's sum is greater than 10 million. Does anyone know why this is not working and if there is a way to successfully accomplish what I need?
Thank you
Try this:
=If(Aggr(Sum(TOTAL <PROD_DT, REL_CD> VALUE), REL_CD) > 10000000, REL_CD))
Try this:
=If(Aggr(Sum(TOTAL <PROD_DT, REL_CD> VALUE), REL_CD) > 10000000, REL_CD))