3 Replies Latest reply: Nov 15, 2013 3:54 AM by Razor Ramon RSS

    Create expression in Script rather than Front End

      Hi guys,

       

      This should be pretty straight forward, but it is not working as expected for me.

       

      I have 5 expressions as follows

       

      sum(C1_K)/sum({<C_Date={'<=$(=today()-1)'}>}Value)

       

      sum(C21_K)/sum({<C_Date={'<=$(=today()-21)'}>}Value) and so on

       

      The expressions cause my front end to slow down when this chart is displayed.

       

      I would like to move this to the script to simp-lify the calculation.

       

      I tried if(C_Date = today()-1, 1,0) as C1_K_Flag

       

       

      When I put this back in my expression as sum(C1_K)/sum(C1_K_Flag * Value), it doesn't work and comes up with a blank chart.

       

      Can someone please tell me what I am doing wrong?

       

       

      Thanks