@User_RJHPO PERIODROLLING("Financials - AR Revenue"."Facts - Document Currency"."Revenue Amount", -12, 0)

I tried with case statement for each period, and it worked.

I am using PERIODROLLING function to get 3 months rolling revenue. I am getting correct values under column 'Total 3 M Rolling Revenue' except for last month Jan 26(Trailing period number=1) getting calculation wrong. it should sum(revenue amt) for trailing period number =1,2 and 3 but it is skipping trailing period number…

Yes, I used trailing period number using filter from 0-11. what are corresponding fields from AR Revenue and Transactions to calculate DSO. Please refer if I need to use any other subject area. Thank you!

I am using Financials: AR Revenue, AR Transactions.

Thank you!

Header data font is not bold and at column level data font is also not bold still values under columns are bold. see original amount column at column level, report still shows bold data