9 Replies Latest reply: Sep 9, 2012 4:21 AM by Jason Michaelides RSS

    I have a text box where in I have to show the count of the account number whose sum(Product bookings net ) is greater then the number that user entered into the input object

    Shashank Seth

      Hi Masterminds,

       

      I have a text box where in I have to show the count of the account number whose sum(Product bookings net ) is greater then the number that user entered into the input object

       

      I have used all possible approaches including sets

       

      =count(

       

       

      {<

       

       

      [Product Bookings Net] =

      ({'$(=vSum)'} * {'>=$(=vPickup)'})

       

       

      >}[Account Name])

       

      where vSum = aggr(Sum([Product Bookings Net]),[Account Name])

       

      and vPick= the value entered by user

       

      but its not working

       

      please reply fast I have to submit it today

       

      Thanks in advance