Andrii Posted June 27, 2018 Report Share Posted June 27, 2018 Can anybody share Caspio solution for Norm.Dist function from Excel? Quote Link to comment Share on other sites More sharing options...
0 Vitalikssssss Posted June 27, 2018 Report Share Posted June 27, 2018 Hi there, You can create an equivalent of Norm.Dist function by using the calculated field which is available on Report type of Datapage. I have this T-SQL example as a guide. I have created my example based on Details page. Your table needs to have following values: 1. Sigma; 2. Mean; 3. Value; and following set of calculated fields: 1. @x Expression: (([@Value] - [@Mean]) / [@Sigma]) 2. @Z Expression: (ABS( [@calcfield:@x] ) / SQRT( 2.0 )) 3. @t Expression: (1.0 / (1.0 + 0.5 * [@calcfield:@Z])) 4. @ans Expression: [@calcfield:@t]*exp(-[@calcfield:@Z]*[@calcfield:@Z]-1.26551223+[@calcfield:@t]*(1.00002368+[@calcfield:@t]*(0.37409196+[@calcfield:@t]*(0.09678418+[@calcfield:@t]*(-0.18628806+[@calcfield:@t]*(0.27886807+[@calcfield:@t]*(-1.13520398+[@calcfield:@t]*(1.48851587+[@calcfield:@t]*(-0.82215223+[@calcfield:@t]*0.17087277)))))))))/2.0 5. normdist (output) Expression: case when [@calcfield:@x] <= 0 then [@calcfield:@ans] else 1 - [@calcfield:@ans] end You may refer to my DP for more details. Regards, vitalikssssss Quote Link to comment Share on other sites More sharing options...
0 Barbie Posted May 3, 2019 Report Share Posted May 3, 2019 You can also refer to this link on how to create a calculated field in a Report DataPage https://howto.caspio.com/datapages/datapage-components/calculated-values/ Quote Link to comment Share on other sites More sharing options...
Question
Andrii
Can anybody share Caspio solution for Norm.Dist function from Excel?
Link to comment
Share on other sites
2 answers to this question
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.