Skip to Content
0

Dates as column results

Jul 10, 2017 at 02:56 AM

17

avatar image

Hi All,

I have a report where I require that the posting start and posting end relative to that material occurs in the column and not in the row

Material posting start posting end days taken
AAAA 16.10.2016 17.10.2016 2
bbbb 18.12.2016 18.12.2016 1

The thing is that the posting start / end is a selection in itself - combination of date and movement type, so I think using global variable may not work. So I am looking for two things - the selection to return the date, not a key figure - and the formula - days taken - to be able to calculate the amount of time between the two dates.

Is this possible in Bex without going back to the model?

Denise

10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

0 Answers