Formula is not working....need help..

[#1]

Hello every one,

I need your help here.... i have a very small formula    sum({<[Contra Type]={Revenue},Quarter={$(vQuarterComparison)}>}Total)  

which is troubling me...vQuarterComparison is a Variable which picks same quarter in the prev Year(=left(Quarter,3)&''&num(right(Quarter,2)-1,00))..

Please help me out and let me know why the above formula is not working..

Thanks & Regards,

Venkat T

[whiteline]

try

sum({<[Contra Type]={Revenue},Quarter={=$(vQuarterComparison)}>}Total)

or

sum({<[Contra Type]={Revenue},Quarter={"=$(vQuarterComparison)"}>}Total) 

[jvitantonio · Accepted solution]

I would try

sum({<[Contra Type]={Revenue},Quarter={$(=vQuarterComparison)}>}Total)

or

sum({<[Contra Type]={Revenue},Quarter={"$(=vQuarterComparison)"}>}Total)

[Miguel_Angel_Baeyens]

Hi Venkat,

Note that both right parts in your set analysis are texts, so you will need to wrap them by single quotes:

Sum({< [Contra Type] = {'Revenue'}, Quarter = {'$(vQuarterComparison)'} >} Total)

You can find more on how to use quotes in set analysis in this post.

Hope that helps.

Miguel

[#5]

Thankyou so much to all of you..my issue is resolved...

Thanks & Regards,

Venkat T