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. I’ve attached screenshots for reference. Could someone guide me on why these formulas are not working and how to correctly calculate these measures for a calculated field like Lead Time?
