My Stuff

Avatar
Check out Oracle NetSuite upcoming events and conferences here
See All the Unlockable Badges See All the Unlockable Badges
Now is the time to ask your NetSuite-savvy friends and colleagues to join the NetSuite Support Community! Refer now! Click here to watch and learn more!
We’re ringing the bell so you know what that means… LAST CALL! This is your last week to register for #SuiteWorld at our early bird special rate and save $300. Join us for our biggest event of the year and learn more about how your business can get the most out of our system. https://lnkd.in/enaAr8p8
Release 2022.2 is Coming! – Get Ready with your Release Preview Account
Attention: Customers with NetSuite Electronic Bank Payment (EBP) SuiteApp, version 2020.2 QA (ID 315896) must UPDATE (do NOT uninstall) their bundle to the Production version 2022.1 (ID 416781) by December 31, 2022. Note: If users fail to manually update the Electronic Bank Payments SuiteApp within the given time window, this version of the SuiteApp (ID: 315896) will be deprecated and the account will not be updated to Leading version (2022.1) of the Electronic Bank Payments SuiteApp. Please refer to the campaign email sent to impacted customers for more information.

Petr Maly-Oracle Red Ribbon

About

Display Name
Petr Maly-Oracle
Joined
Visits
53
Last Active
Roles
Member, ORACLE_EMPLOYEE
Points
680
Badges
10
Region
EMEA
Expertise
Analytics
Basic
1
Posts
5

Comments

  • Hello @emcee_uk , upon checking with our engineering team it looks like there is some limit for exported file. It is not directly based on number of rows nor columns but rather on size of the output csv file. So the only workaround I can suggest is to export datasets in batches and then put csv files together locally.…
  • Hello @emcee_uk , I was able to export dataset with 27 columns and more than 1M rows just now, so the limit mentioned above in the Enhancement probably does not apply here. Anyway, it is clear that there is a lack of indication in the system that the export is ongoing. For me it took couple of minutes before the file was…
  • Hello @srussell , The behavior you expect is unfortunately not supported at the moment. The formula you came up with is basically the best solution you can have for your case here. Also, I have to admit that there is not a good example of using BOOLEAN formulas in our documentation so I will make sure this is addressed.…
  • Also, let me summarize here some formulas for YoY comparison you might find useful: This Quarter CASE WHEN TO_CHAR({trandate},'Q') = TO_CHAR(CURRENT_DATE,'Q') AND EXTRACT(YEAR FROM {trandate}) = EXTRACT(YEAR FROM CURRENT_DATE) THEN TO_NUMBER({foreigntotal}) END This Quarter Last Year to Date CASE WHEN…
  • Hello Christine, thank you for your comment, adding here fixed Last QuarterTo Date filter: CASE WHEN TO_NUMBER(TO_CHAR({trandate},'Q'))-1 > 0 AND TO_NUMBER(TO_CHAR({trandate},'Q'))-1 = TO_NUMBER(TO_CHAR(CURRENT_DATE,'Q'))-1 AND EXTRACT(YEAR FROM {trandate}) = EXTRACT(YEAR FROM CURRENT_DATE) THEN TO_NUMBER({foreigntotal})…