Variables

[khaycock]

Any idea why this expression doesn't work?

I feel like the syntax is right but it says it is expecting another '}' somewhere

=sum({$(vYTD)}[Total Revenue])

[Anil_Babu_Samineni]

May be this?

=sum({< $(vYTD) >}[Total Revenue])

[sunny_talwar]

How do you define your variable vYTD?

May be you need this

=Sum({<$(vYTD)>}[Total Revenue])

[khaycock]

Nope still has the same error

[khaycock]

Nope still has the same error

[Anil_Babu_Samineni]

Would you declare the variable

[sunny_talwar]

How do you define vYTD?

[avinashelite]

what is the condition your trying

=Sum({<Feild_name={'$(vYTD)'}>}[Total Revenue])

you need to define the left hand side

[vishsaggi]

Is this right way?

= Sum({< [Total Revenue] = {'$(vYTD)' } >} [Total Revenue])

[avinashelite]

Whats the value you have in vYTD and [Total Revenue] ?

Eg. vDate=07/03/2017

and feild = date ... and has value like 07/03/2017, 08/03/2017 ,09/03/2017

= Sum({< [date] = {'$(vDate)' } >} [Total Revenue])