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
Fields!Store_Stock_Level.Value *(Fields!PS.Value - ((Fields!PS.Value * Fields!VAT_Rate.Value)/100))