Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this:
=Sum(if([Division]='Electronics',if([Fiscal Quarter]='2013-4',sum([USD Product Bookings]),0),0))
Try this:
=Sum(if([Division]='Electronics',if([Fiscal Quarter]='2013-4',sum([USD Product Bookings]),0),0))