Hi Guys, I am trying to calculate strange "forecast" for client which should show sum of values for current month till the end of the year - I've built this function and it works okey for non blank values. It seems that if there is no real data for example March in forecast value from February is shown instead of blank(for example if service was not provided this month) . Could you please advice how to handled blank values in forecast?
Solved! Go to Solution.
Could you give an example of your dataset showing on this table(or matrix?) and show me how you calculate the measure"forecast"?
Which data is orginal data and which are from your measure?
Ashish, one more thing. I would like grand total to show sum of my calculated field -( I am talking about the formula I wrote in file previously) - Why they are so different ? (The last show result from sum formula)
Your question is not clear. Do you want the Grand total appearing in column N of the image that i posted to be the summation of the numbers from column B:M?