Stock coverage report

Wed, 15 Jul 2015 14:14:15 GMT

Hi!

I have some troubles at this report.

1 - (blue squares) Stock at Totals is Sum(), can i put last-month value to totals?

2 - (red squares) Cant calculate Stock Coverage value, it need: current-month stock / next-3-month sellout

Can someone help me?

Re: Stock coverage report

Wed, 15 Jul 2015 14:30:00 GMT

First question is ok.

solution: //in this case last month of year is March

IF(Count(DISTINCT [Calendar Month])=3

,sum({<[Calendar Month]={'Jun','Sep','Dec','Mar'}>} Val)

,IF(Count(DISTINCT [Calendar Month])=12

,sum({<[Calendar Month]={'Mar'}>} Val)

,sum(Val)

)

isnt best solution, but work fine.

still lookin' for second answer.