Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to use the following in an expression to populate a field in a chart and it is not returning a value:
=IF([TEH] = 'A',SUM({$<[Month] = {'M1'}>} [TotalEmpl]))
This part does return the value when used outside of the chart
=SUM({$<[Month] = {'M1'}>} [TotalEmpl])
What am I doing wrong?
What about this:
=Sum({$<[Month] = {'M1'}, TEH = {'A'}>} [TotalEmpl])
try this if you want to display the result for [TEH]= A
SUM({$<[Month] = {'M1'}, [TEH]={'A'}>} [TotalEmpl])
If it's not working please provide more details
which chart?
what are dimesion?
what are expression?
If you selects A from [TEH], probably your will get the value of your expression..
Best part is always use SET Analysis, Sunny Thave already suggested you same
=Sum({$<[Month] = {'M1'}, TEH = {'A'}>} [TotalEmpl])
This still returns a value of 0. When I apply this to a simple textbox outside of the chart, I get the correct value. I'm not sure what is wrong. What other information can I provide that will help? I am very new to all of this.
Is it possible to share a sample?
I think Your period is not associated with MCR heading. See the screenshot.
When I am selecting any MCR Heading. Period is blank
Also I checked your data model which involves many synthetic keys. Try to optimize your data model.