Link to home
Start Free TrialLog in
Avatar of innocent1973
innocent1973

asked on

SSRS : SUM of SUMs

Hello Experts,
I have a SSRS reports that displays weekly sales and Store inventory levels. In this report, I have used a calculated member named "Branch Stock Value". And its expression is:

Now, I would llike to use another calculated member that uses this BranchStockValue member. My desires calculated member expression is:

BranchStockValue / SalesValue

I get divide by zero or other null errors. But the final purposed result is really very easy.

I have also attached a screenshot that displays my report layout. For example for the first line Branch Week Cover value should be 12544.36 / 1656.39 =  7.57


Please help
Fields!Store_Stock_Level.Value *(Fields!PS.Value - ((Fields!PS.Value * Fields!VAT_Rate.Value)/100))

Open in new window

weeklyreport.png
ASKER CERTIFIED SOLUTION
Avatar of Eduardo Goicovich
Eduardo Goicovich
Flag of Chile image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial