Set Analysis to Consider Current Field Selections

[triekong]

i want to find the Year to date Actuals for only if my Org Level 3 = Geo Services.

my analysis formula that says:

=Sum({<FYear={$(vMax_Year)}, fMonth=,[Org Level 3]={'Geo Services'}>}[Actuals])

now when i select another value in that same Org Level 3 field, my result stays the same, while i want it to go to "0".

how do i say, i only want a result, if the Org Level = "Geo Services". so that if the user selects Org Level 3= Finance, my answer goes to 0.

should i use a SUMIF instead, or is this possible with set analysis.

[trdandamudi]

Give a try on the below:

=If(GetFieldSelections([Org Level 3])='Geo Services',Sum({<FYear={$(vMax_Year)}, fMonth=,[Org Level 3]={'Geo Services'}>}[Actuals]),0)

[vamsee]

Try adding an asterisk like below

Sum({<FYear={$(vMax_Year)}, fMonth=,[Org Level 3]*={'Geo Services'}>}[Actuals])