2 Replies Latest reply on Dec 10, 2013 8:21 AM by ultranix

    Simple standard deviation (Excel's STDEV.S)



      Simple standard deviation (Excel's STDEV.S)


           Hey, I've encountered, that Filemaker's StDev function uses such formula:

           While Excel's STDEV.S (the function i try to implement) uses different formula: 

           I first tried to search this forum, came up with a thread , downloaded the latest version of example file and i need the result, which is achieved by sSTDv field (summary, option: Standard deviation of, field: Hours), i just use not the main table (BASE), but occurence of it (BASE_3Months), so i cannot have summary field on table occurence, just on the main table.

           How can i solve this?