Unable to calculate Average, Standard Deviation, and Variance for Derived Lead Time Field

Sushmeeta

I have a dataset with two date fields: Load Date and Delivery Date. I calculate Lead Time as "Delivery date-load date". Now, I need to compute the following statistical measures for this Lead Time: Average (Mean), Standard Deviation,Variance. However, when I try using formulas like Subtotal (sub function code, x, y), AVG, STDDEV, or VAR, they do not return the expected results.

Gavin Murray

Hi @Sushmeeta,

Thank you for explaining the challenge you’re facing with calculating the statistical measures for Lead Time. I understand how important it is for these calculations (Average, Standard Deviation, and Variance) to return accurate results, especially when working with date-based metrics.

To guide you correctly, could you please confirm where you are encountering this issue?

• If this is in an Academy course, please share the exact course and sub-course name — for example: Level 200 / Level 300 → Subcourse 204: Build Sales Data Model → Step 5.
• If this is in your home instance, please provide the following details:
  • Your company name and email address
  • The instance name where you are facing the issue (e.g., test-c1, s1, etc.)
  • Your complete Board version
  • Additionally, could you please record a short video while performing the steps, as it will give us more clarity on the issue.

Once I have this information, I can assist you more accurately.

Looking forward to your update.