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
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))
weeklyreport.png
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.