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(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?