Question
IN
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
JP Morgan Chase & Co.
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.
IN
Any suggestion on how we can get month name from Funtion Alias?
Pegasystems Inc.
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,
IN
I dont think we can write Expression in report definition