Value is not showing at set analysis

[#1]

Hello Everyone,

Can you please help in this

i used set like below, expression is ok, but not getting any values

=sum({<Year_No={$(vYear)},Manager={'Harsha'}>}[Revenue])

any one please correct me if i wrote wrong syntax

Thanks

[amit_saini]

Try this:

=sum({<Year_No={$(vYear)},Manager={'Harsha'}>}Revenue)

Thanks,
AS

[#3]

Still not getting the value

[Miguel_Angel_Baeyens]

Hi,

Are the contents of field Year_No and variable vYear the same?

Does vYear store a function or just a literal?

Do you have any selections that may avoid that expression to return values?

Miguel

[amit_saini]

Please share your application.

Thanks,

AS

[sibideepak]

Hi Sreeharsha V

Have you tried this one ,

=sum({<Year_No={$(=vYear)},Manager={'Harsha'}>}[Revenue])

Thanks

Deepak

[sudeepkm]

when you say that you are not getting values can you please let us know if you are seeing a zero as result or you are seeing just a "-".

Also you may check if the selection combination in your set analysis has data present or not. that means for Manager name "Harsha" please check if you have data present for the selected years.

Can you please post the screenshot of the variable and expressions ?

[vardhancse]

Try,

sum({$<Year_No={'vYear'},Manager={'Harsha'}>}[Revenue])

[#9]

Sorry Not working

[#10]

I am getting zero value