Level 3: Behavior This step is crucial for understanding the true impact of the training. It measures behavioral changes after learning and shows if the learners are taking what they learned in training and applying it as they do their job. It also looks at the concept of required drivers. That is, “processes and systems… Continue reading What is the Kirkpatrick Training Evaluation Model? (Part2)
Month: July 2023
From Concept to Screen: Demystifying the Budget and Time Duration of Creating an Animated Feature Film
Introduction:Creating an animated feature film is a remarkable endeavor that requires meticulous planning, dedicated teams of talented individuals, and a well-structured production pipeline. As audiences immerse themselves in the magic of animated storytelling, it’s fascinating to uncover the intricacies behind the scenes. In this article, we delve into the world of animation and shed light… Continue reading From Concept to Screen: Demystifying the Budget and Time Duration of Creating an Animated Feature Film
To generate a report in Jira that includes tasks with completed QA and their related QA tasks, you can follow these steps:
Create a Jira filter: Navigate to the Issue Navigator in Jira. Click on the “Advanced” search option. Enter the following JQL query to filter tasks with completed QA and their related QA tasks:sqlCopy codeissuetype = Task AND status = “QA Done” AND “QA Task” IS NOT EMPTY AND “Epic Link” IS NOT EMPTY If you… Continue reading To generate a report in Jira that includes tasks with completed QA and their related QA tasks, you can follow these steps:
If some fields are hidden in the Issue Navigator in Jira, you can follow these steps to find and display them:
Navigate to the Jira dashboard. Click on “Issues” in the top navigation bar. In the drop-down menu, select “Search for issues”. This will take you to the Issue Navigator. On the Issue Navigator screen, click on the gear icon labeled “Columns”. In the “Columns” dialog box, scroll down to the bottom and look for the… Continue reading If some fields are hidden in the Issue Navigator in Jira, you can follow these steps to find and display them:
Expose the Number of Transactions Created per Hour in Saved Search
On a Transaction Saved Search, the user wants to expose the number of Transactions Created per Hour. Solution Navigate to Lists > Searches > Saved Searches Find the Saved Search in concern Click Results Click Columns Fields: Select Formula (Numeric) Summary Type: Select Maximum Function: Select Round Formula: Enter sum(case when {systemnotes.type} = ‘Create’ and {systemnotes.field} = ‘Record’ and to_char({systemnotes.date},’hh24′) = ’16’ then 1 else 0 end)/NULLIF(count(distinct case when {systemnotes.type}… Continue reading Expose the Number of Transactions Created per Hour in Saved Search
Format and Specify Rounding of Formula on Saved Searches
Round Function available on Saved Searches is limited to Round, Round to Tenths, and Round to Hundredths. However, there can be a specific rounding off and format for formula values on Saved Searches (i.e. ”999,999.9999”). Example: Create a sales search and divide the sales amount by 3. The result should have the format 999,999.9999 Solution… Continue reading Format and Specify Rounding of Formula on Saved Searches
How to use SUMIFS formula in excel
SCENARIO Let us understand the ysage and how to use the SUMIF formula as an example. Here is table given below we require to get the total of each indvidual seperately. Name Amount Peter 15 Paul 20 Paul 30 Peter 15 Solution In the excel sheet type the name of the individuals seperately as hown… Continue reading How to use SUMIFS formula in excel
Get the image URL from the NetSuite
If we know the internal id of the image file, we can fetch the image URL using a document saved search from the image file in the file cabinet instead of fetching the image from the item record.
Tax Calculation – Order level
Taxes can be applied to sales orders/cash sales in NetSuite on order level. In NetSuite taxes can be set up on customer level and the tax set up for customer will be automatically reflected in the sales order created for the customer. To remove these taxes, we can use the check box field ‘TAXABLE’. If… Continue reading Tax Calculation – Order level
Uninstalling a Bundle
Uninstalling a managed bundle ends all upgrades to that bundle in your account. To uninstall a bundle: Log in to the account in which you installed the bundle. Go to Customization > SuiteBundler > Search & Install Bundles > List. Choose Uninstall from the Action dropdown list for the bundle you want to uninstall. In the confirmation popup, click OK. Warning:Uninstalling… Continue reading Uninstalling a Bundle