2 Replies Latest reply: Jun 28, 2013 2:37 AM by tmyicecream RSS

    Data between specific range

      Hi,

       

      I would like to make below 2 different expressions to 1. Could you pls let me know how can I do it?

      I want to show up the data which is from 2000~5000.

       

      =if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))>=2000,sum(if([Notification Date]>ReloadTime()-365, [Cost])))

       

      =if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))<5000,sum(if([Notification Date]>ReloadTime()-365, [Cost])))

       

       

      Thank you very much for your help in advance.