Subtraction in SET

[#1]

Hi All,

I'm trying to do a minus (subtraction) using SET but it only returns the first row of data and doesn't return the second row of data.

Please provide assistance.

Thanks,

[alexdataiq · Accepted solution]

Maybe try this:

=money(

     sum({<Department={'Technology'}, [Fund Manager]={'Goldman Sachs', 'Smith Barney'}>} Sales)

     -

     sum({<Department={'Finance', 'Marketing', 'Corp Bond Sales'}, [Fund Manager]={'Goldman Sachs', 'Smith Barney'}>} Sales)

)

Cheers

[sunny_talwar]

Its difficult to know what you are trying to do just by looking at the expression. Do you have a sample that you can share with us?

[#4]

Thanks Guys for all your help!!!!!

[alexdataiq]

Glad to help!