Set Analysis

[#1]

Hi All,

Can someone tell me what's wrong with the below formula.

=(Sum({[BookRev]<QuarterNum={"$(=Max({$}QuarterNum))"}, [DimYear] ={"$(=Max({$}[DimYear]))"}>} grossamount)

-

Sum({[BookRev]<QuarterNum={"$(=If(Max({$}QuarterNum) - 1 = 0, 4, Max({$}QuarterNum)-1))"}, [DimYear] ={"$(=If(Max({$}QuarterNum) - 1 = 0, Max({$}[DimYear]) - 1, Max({$}[DimYear])))"}>} grossamount) * 4

/

Sum({[BookCost]<QuarterNum={"$(=If(Max({$}QuarterNum) - 1 = 0, 4, Max({$}QuarterNum)-1))"}, [DimYear] ={"$(=If(Max({$}QuarterNum) - 1 = 0, Max({$}[DimYear]) - 1, Max({$}[DimYear])))"}>} grossamount))

When I apply these formulas separately they all work, once I put all of these together in one formula it only gives me the value for the first part (the one in the orange).

Thanks in Advance,

[swuehl]

Could you upload a small sample QVW that demonstrates the issue?

It's hard to tell what's wrong without knowing the context.

[#3]

Please find attached the sample sheet.

[sunny_talwar]

What is the output you are hoping for? With and without selections?

[swuehl · Accepted solution]

You essentially calculate something like

A - B/C

You don't get just A, but B/C results in a number much smaller than A, that's why you think you only get A.

Maybe you want to calculate

(A-B ) / C

?

Then just add parentheses accordingly.

[#6]

Thanks Stephen for you help