Hello all,
I have a small issue. I need to display what percent my bottom line is to gross sales? Any ideas? The current percentages are based on this calculation.
IF(Dimensionality() = 1 and RowNo() <> 1,(sum({<MTDFlag = {1}>} [In company code currency_HSL] * -1 ) /
top(sum({<MTDFlag = {1}>} [In company code currency_HSL]* -1 )))* -1)
Thanks