My Stuff
New AI Community Guidelines. Please review and follow them to ensure AI use stays safe, accurate, and compliant.
-
Re: SuiteAnalytics Dataset Group By
Hello @Jeroen Sprangers ZS Welcome to our Community! I reviewed your inquiry about SuiteAnalytics workbook. Apparently, Dataset could only contain the fields and formula details, but it does not have…3 -
Re: Summarized Saved Search Formula Field Skews data
Hi @Tafara , Red here again ? I see that you are inquiring for your custom fields count. Based on your screenshots, it is grouped using COUNT. What do you mean by having wrong results? Is it differen…1 -
Re: Formula To Return Employee Name If Project Role End Date Is In the Future
You're welcome @Tafara .. You can try to remove/add joined fields on your Project search (if the formula is working fine with Project Tasks) See sample below: Try the {projecttask.custevent_hw_r…1 -
Re: Formula To Return Employee Name If Project Role End Date Is In the Future
Hi @Tafara Your formula looks valid, I tried it on a Project search and it is working fine. If you are in a transaction search, try to convert it as: DECODE({accounttype}, 'Income', {amount…1 -
Re: Formula To Return Employee Name If Project Role End Date Is In the Future
Hi @Tafara , You can try and play around with this formula below: CASE WHEN {startdate} < {today} AND {enddate} > {today} THEN 'ACTIVE' ELSE 'Inactive' END Please Note: Repl…2
