Question

Finding % of Month completed

  • 4 April 2019
  • 0 replies
  • 10 views

Hi There,


I am trying to create a custom filter to find the % of this monthly completed, to then populate a data table which has a Utilisation % Column, for records that have greater utilisation % than the month completed. such as if utilisation is 90% however monthly completed is only 50%


for example i have:

if(

trunc_days(now())>=25,

${utilisationpercent}>=0.85,

${utilisationpercent}>=0.01,

)


How should I do this?


0 replies

Be the first to reply!

Reply