We have a requirement where user wants to apply/perform some formula like SUMIF, IFERROR etc., which are generally used in Excel while doing reporting using Report definition. Is there any way in Pega to apply these formulas? Also please confirm if Pega Platform have excel plugin support. If so, can open the grid/result set returned by report definition in Excel and apply the mentioned formula.
You cannot use these excel functions directly in a Report Definition other than the ones listed under the Summarize column. However, you always have the option to export the results into Excel by clicking on the Actions->Export to Excel once a report is run . Once you download the excel, you can enable the file and play with the output as you please.