Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I have a straight table that my dimension is like this:
=if(im_projectID=8231 or im_projectID=8194 or im_projectID=4302 or im_projectID=8230 or im_projectID=10117 or im_projectID=694 or im_projectID=10677 or im_projectID=10536 or im_projectID=10512 or im_projectID=5594 or im_projectID=11518 ,im_projectID)
and for expression I have sum (im_ProjectBudget). I want to get the max of (im_ProjectBudget) for just these im_projectID, not for all of them.
how can do it?
You can replace your calculated dimension with a simpler one like:
=If(Match(im_projectID, 8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518), im_projectID)
And then the expression like:
Max( TOTAL {<im_projectID={8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518}>} im_projectID)
You can replace your calculated dimension with a simpler one like:
=If(Match(im_projectID, 8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518), im_projectID)
And then the expression like:
Max( TOTAL {<im_projectID={8231,8194,4302,8230,10117,694,10677,10536,10512,5594,11518}>} im_projectID)