Question
Putumbaka
US
Last activity: 14 Jun 2021 7:38 EDT
Display Count as per month
Hi
We have a report definition showing volume as per createdatetime month.
but my report is showing Aug 50 Aug 70
Aug 22
it shows as 3 AUG sum for single id
Rather it should show as single AUG 144
Attached screenshot for better understanding..
Accepted Solution
Updated: 14 Jun 2021 7:38 EDT
Pegasystems Inc.
IN
Currently, I think you are displaying the month value by using the format but the count is getting for each date. We need to have custom function alias to get the month name from the DateTime value, then we can get the count per month.
Capgemini
IN
Hello,
To get the month name from the DateTime value, use the following expression in the expression builder.
@(Pega-RULES:DateTime).FormatDateTime(@(Pega-RULES:DateTime).CurrentDateTime(), "MMM", "", "")
Thanks,