megaphone
Update your Profile with your Support type to get your Support Type badge.
Nominate Your Peers for NetSuite Support Community's Choice of the Quarter! Submit your nomination today.
Stay in the know of how NetSuite can help grow your business with our guides, webinars, and events. Subscribe Here
What Topic Should We Cover Next? Your idea could be our next feature—drop your suggestion now!
No Limits. Just possibilities. Join us for complimentary one-day events around the world and step into a future fueled by AI and limitless potential. Discover what's next at SuiteConnect Tour 2026.
Try Intelligent Payment Automation – Fee Free For Your First Month For more information, visit this thread.
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Expand your NetSuite knowledge by joining our Ask A Guru Live sessions. RSVP on this event now.

My Stuff
Default Avatar
See All the Unlockable Badges See All the Unlockable Badges
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
Update: Narrative Insights has been restored and is now available.

Narrative Insights is Temporarily Unavailable due to an Infrastructure Issue. Learn how This Impacts Your Account and What to Expect While the Feature is Disabled.

3946233 Newbie

Comments

  • To get this to work you need a custom 'Item' search with NO criteria and 'Component Item' as an available filter. You also need to tick the 'Available as Sublist' box at the top ... and you need some result fields (I have Name, Display Name, Description, Base Price etc..) Once you have your search you need to use it to set…
    in Item Group Membership - Reversed Comment by 3946233 Feb 6, 2012 5:16AM
  • Thanks Dave! I should have been more specific: I need the count of contracts totaled for this month and two months ago for each coach - which is why I had the coaches grouped. Any ideas on the two formulas for grouping the different time frames? Thanks! Try this (remember to replace STARTDATE with your actual start date…
    in Formulas for This Month and Last Month Comment by 3946233 Feb 6, 2012 5:59AM
  • Do I have the syntax right on this expression? case when INSTR(TO_CHAR({trandate}) , TO_CHAR({today}, 'fmYYYY') > 0 then {amount} else 0 end If you are just looking to pull out Transactions from this year you could just use a date filter. Otherwise, to fix your formula you need to provide a format for the {trandate} to…
    in How to display just the year from today Comment by 3946233 Feb 6, 2012 4:29AM
  • I am trying to use the formula below, but keep getting an invalid expression error. I'm not sure what I am doing wrong. It works if I remove the transaction date section, but when I put it back in it fails. case when {transaction.trandate}>LAST_DAY({today},-1) and {transaction.type}='Cash Refund' or…
    in Formula Help Comment by 3946233 Mar 2, 2012 4:31AM