Skip to main content
Question

Action flow data does not match with Analysis sheet data

  • September 24, 2025
  • 4 replies
  • 36 views

Forum|alt.badge.img

Hi 

   We are seeing a strange issue where we are using the exact same formula as in Analysis for a KPI, however the data on excel generated by action flow is about 2% different from that on the analysis sheet. Has anyone encountered similar situation and what was the resolution?

 

4 replies

julia.bauer
Level 9
Forum|alt.badge.img+1
  • Level 9
  • 58 replies
  • September 24, 2025

Hello ​@arun.ramam11, could you please share the AF module setup? 

Thanks and BR,

Julia Bauer


Forum|alt.badge.img
  • Author
  • Level 2
  • 2 replies
  • September 24, 2025

We are using KM with data model reference on action flow but KPI formula is the same on analysis sheet and Action flow


Forum|alt.badge.img
  • Author
  • Level 2
  • 2 replies
  • September 25, 2025

Is there any suggestion or possible reason for why the data on excel sent on mail may be slightly off from data on analysis sheet?


Suveesh Malachiyil
Level 1

Hello ​@arun.ramam11

 

The possible issues could be 1.) Filters applied in analysis or in the action flow module 2.) check if there is any variable in the KPI PQL and if any mismatch in both 3.) row limit in celonis get rows module 4.) double check the data structure in xlsx module.

 

Best Regards,

Suveesh Malachiyil