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:
Fields!Store_Stock_Level.Value *(Fields!PS.Value - ((Fields!PS.Value * Fields!VAT_Rate.Value)/100))
Now, I would like 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.
For example for the first line Branch Week Cover value should be 12544.36 / 1656.39 = 7.57
View Complete Post