Hello,
I am trying to calculate percent of total for a calculated field I.E., on time or late status , fixed for each month
in the column section I have put completed date (MONTH) and Calculated field for Status with below calculation
ifelse ( completed date>due date, “Late”, On-time)
In values I put the count of orders to understand how many orders delivered on time or not
I want to calculate the percent total of On time ( eg. 88.9) and Late (11.1) giving a sum 100%
Fields in use
Name
Complete Date
Due date
Number of orders
Status (Calculated field)
can I say percentOfTotal(sum({Number of order}),[{Completed Date},{Status}])