How to write the Set Analysis Formula to avoid list box selection

[bvssudhakar]

Hello Experts,

I have an Expression: =Sum([Total No. of Openings])- Sum(Placed)

Now i want to show that output for only one particular selection and it will show same result whatever selections we select that means i want avoid list box selection

For that i wrote like this but it's wrong, can you guys please give correct expression

=Sum({<{([Total No. of Openings])-(Placed)},[Job Status]={Open},StatusofJob={Billable}>}

Job Status, StatusofJob both are list boxes

Thank you in advance

[trdandamudi]

May be as below:

=Sum({1<[Job Status]={'Open'},StatusofJob={'Billable'}>}  [Total No. of Openings]-Placed)

[mikecrengland]

It should look something like this:

=Sum({<[Job Status]={'Open'},StatusofJob={'Billable'}>}Total No. of Openings])

Don't forget the quotes...

mike

[lfholland · Accepted solution]

I would try what Michael suggested and doing the same with Placed:

=Sum({<[Job Status]={'Open'},StatusofJob={'Billable'}>}[Total No. of Openings])

-

Sum({<[Job Status]={'Open'},StatusofJob={'Billable'}>}Placed)

[bvssudhakar]

All Answers are working, Thank you very much guys