If works, set analysis doesn't?

[Anonymous]

Hi All,

I was wondering if anyone might be able to shed a little light onto something I don't understand.  I have a fairly simple formula:

if([Rate Type] = 'DCS', [Comm TCV] * [Rep Comm Rate %])

This works in my straight table.  However this does not:

=SUM({$<[Rate Type] = {'DCS'}>}[Comm TCV] * [Rep Comm Rate %])

It only returns zeros.  I was just curious if there was some reason why it may not work.

[Anonymous]

But it appears that it works fine when it's broken up into two parts.

([MRR] * Term_Flag)              AS [MRR Comm TCV] - This is returning positive values (as expected)

([Churn MRR] * Term_Flag)   AS  [Churn Comm TCV], - This is returning negative values  (as expected)

However, it seems no matter what formula I use to try and combine the two it either returns only negative or only positive.

[swuehl]

Hard to tell what the issue might be.

Could you give any examples for the input records and what you get as result of your calculations?

If one part is always much larger in absolute value than the other, I wouldn't be surprised to see only positive or negative values.

[Anonymous]

Attached an excel doc of the data dumped from the app.