MY TP90 showing in number but I want to show in decimal point.
This is my formula to calculate TP90:
percentile({Cycle days},90)
Hi @hripraa, you can potentially change the format by selecting the ellipses next to the the value, and changing “Format” to include decimal places. For example:
Image includes Dummy data
@Kelseykl Still which is not showing decimal instead it is showing like 5.00,4.00…etc
Did we have any other formula to show in decimal?
Hi @hripraa, I think I am a little confused. Can you provide an example based on the screenshot you provided of what the decimal should display?
@Kelseykl Actually for every week only the decimal points will vary and we will analysis our impact of TP90 by the changes in decimal.
For example: mar10 TP90 for Adsu-LBR Node Genaration is 3.42 but here which is showing 3.00
@hripraa, thank you for the clarification!
If {Cycle days} are integer values then the Percentile (or percentileDisc) function(s) will return a value from the {Cycle days} dataset. So in this case, you will not see a resulting decimal value.
If you want to see the exact percentile value, I would recommend using the percentileCont function.