How to add totals to expression that has condition?

[chiranjivdas]

I have an expression with condition

=if([Division]='Electronics',if([Fiscal Quarter]='2013-4',sum([USD Product Bookings]),0),0)

The expression works fine but i am unable to add totals by using Presentation - Show Partial Sums

How do I add totals?

Thanks,

CD

[ecolomer · Accepted solution]

Try this:

=Sum(if([Division]='Electronics',if([Fiscal Quarter]='2013-4',sum([USD Product Bookings]),0),0))