Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Anyone please help to solve this issue.
// Not Working
SUM({$<Account={'Major','Non-Major'}>}$(vData)) // vData is a variable which pulls data
Thanks!!!
Can you post what vData is defined as?
If(MonthName='FEB', SUM({<MonthName={'NOV'},FYYear={'$(vFYCurrentYear)'},Account="Major","Non-Major"}>}[CurrentData])
$(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)]
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.
your vData should be a field of your data model
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)