Number of decimal places considered in TINV() function

[tas_taba1]

Hello Qlikkers,

I am using the TINV() function to calculate the t-value in my application. I want to know the number of decimal places that are calculated in Qlik sense for this function. Also, I want to know if there is a way to increase the number of places to be considered after the decimal point in the front end of the application?

Any help regarding this will be really great. Thank you.

[Cullin_Tripp]

Hi,

You should be able modify the number formatting (which in turn will make the calculation expand out to additional places) in the properties panel for your chart. Toggle it to custom formatting, and then specify the number of places after the decimal (example below with 10 places).

You can also do this in the expression editor with the Num function:

Num(TINV(myMeasure),4),'#,##0.0000000000')

Hope this helps!