Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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?
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.