Sum Total in Set Analysis

[apthansh]

I have the below expression but How can I put that in set analysis ?

IF(_BTUnitOfMeasure = 'SQF',Sum(Total([RSF])),

                                                 Sum(Total([RSF])) * VarSfTOM2)

Thanks much.

[sunny_talwar · Accepted solution]

May be like this:

RangeSum(

Sum(Total {<_BTUnitOfMeasure  *= {'SQF'}>}[RSF]),

Sum(Total {<_BTUnitOfMeasure  -= {'SQF'}>}[RSF]) * VarSfTOM2)

[miguelbraga]

You can make it something like this:

=Sum(Total {<_BTUnitOfMeasure = {'SQF'}>} ([RSF])) + Sum(Total {<_BTUnitOfMeasure -= {'SQF'}>} ([RSF])) * VarSfTOM2

Let me know if you got it right

Best regards,

D.A. MB

[apthansh]

Thank you.