Variable inside Set Analysis

[bkn]

Anyone please help to solve this issue.

// Not Working

SUM({$<Account={'Major','Non-Major'}>}$(vData))   // vData is a variable which pulls data

Thanks!!!

[danielact]

Can you post what vData is defined as?

[bkn]

If(MonthName='FEB', SUM({<MonthName={'NOV'},FYYear={'$(vFYCurrentYear)'},Account="Major","Non-Major"}>}[CurrentData])

[stigchel]

$(vData) should be the name of a fiield, check by putting =vData in a textbox. Are there spaces in the field name, put square brackets around [$(vData)]

[danielact]

You're using a nested sum, which won't work. You can't have a Sum in your original function as well as in the variable you're calling.

[Anonymous]

your vData should be a field of your data model

[Anonymous]

Looking at your vData expression,

create another field (i.e. a flag) =1 for Month='FEB' in your script (considering this is the only condition you want to use), then write your expression as below,

SUM({<MonthName={'NOV'},FYYear={'$(vFYCurrentYear)'},Account={"Major","Non-Major"}>}[CurrentData]*New_Field)