This site requires JavaScript to be enabled
IE BUMPER

Logo

Dear Tricentis qTest users,

If you would like to submit a Tricentis qTest ticket,

please use this support request form.

Tosca Version
IncidentLookup using list
Language
How can we help?

Solution Suggestions

Please enter your question to get suggestions.
  Help
IE BUMPER
Categories
Boolean Operators
OR or vertical bar symbol (|)
Finds a match if either the terms exist in a document (a union using sets).
AND
Finds a match if both terms exist in a document (an intersection of sets).
NOT, minus (-), or exclamation point (!)
Excludes documents that contain the term after NOT (a difference of sets).
Wildcards
Asterisk (*)
The asterisk symbol performs a multi character wildcard search.
Percent sign (%)
The percent sign performs a single character wildcard search.
Phrases
Quotation marks (")
Use quotation marks to search for an exact phrase with multiple terms.
For examples and more information look at our Knowledge Base: Advanced Search On The Support Portal
38 results in 3 categories found for calc
(ca. Seconds)
Results per page

How to retrieve last 4 digit of a 16 digit string using CALC

This article will help you to retrieve last 4 digit from a 16 or more digit string Situation When one retrieves any values, which has more than 15 digits using CALC function. Calc convert the value after 15th digit to 00 e.g. 1234567891234567 Solution To have all the digi [...]
Number KB0014698
Topic Knowledge Base
Category Guide
State Approval
Published

CALC compendium

This article shows various examples on how to use Excel formulas in Tosca by using CALC Situation Important! If your Calc expression doesn´t work in Excel it won´t either do in Tosca.  Please note that depending on your localization settings chara [...]
Number KB0011963
Topic Knowledge Base
Category Troubleshooting
State Draft
Published 2015-04-12

[CALC] Execution depends on MS Office installation extend

This article describes an error when using EXCEL 2010 incl. MUI-Pack without SP1 and Tosca 7.6.0 Situation An error message gets thrown when executing a CALC function:   "Error 1004 - Open method of the Workbooks could not be executed." TS:TC:->KFZ-Versicher [...]
Number KB0010985
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2014-07-28

How to add leading zero(es) to numbers

You have a number and want to add leading zeroes. Situation This article explains how to add leading zeroes to numbers. For example, sometimes you might deal with numbers that do not have the same number of digits, however the system requires a fixed length for all num [...]
Number KB0014018
Topic Knowledge Base
Category Guide
State Draft
Published

How to sum up values with number format #.##.###,##

Calculations Situation You want to sum up values with number format  #.##.###,##. For that you have used MATH's and TC Set Buffer:  {MATH[{B[Number1]}+{B[Number2]}]}. Afterwards the following error occures: Scripterror 20000 Category >MATH< is no [...]
Number KB0013428
Topic Knowledge Base
Category Troubleshooting
State Approval
Published

Convert total number of Seconds in to HH:mm:ss format

This article shows how to convert total number of Seconds in to HH:mm:ss format. Situation Convert 9084 seconds to 2 hours, 31 mins and 24 seconds. Value which is expected to be stored in buffer is 02:31:24. Solution This can be resolved by using CALC[TEXT] functi [...]
Number KB0014477
Topic Knowledge Base
Category Guide
State Approval
Published

Enter today's date in ordinal notation

This guide will show you how to be able to get today's date with ordinal notation (e.g. 3rd Dec 2018) Situation The requirement is to fetch and convert a date which usually comes in the system format like 12/3/2018 or 2018-12-03 into 3rd Dec 2018. Solution In order for t [...]
Number KB0014185
Topic Knowledge Base
Category Guide
State Approval
Published

Dealing with the complexety of XTestSteps / Extended Reusable TestStep Blocks

Situation WebService test steps can become pretty big, pretty messy and quite complicated to understand. Take a look at the XTestStep that tests some soap web service below. https://tricentis.service-now.com/sys_attachment.do?sys_id=43bfd4da37121e40406642f643990eab" style="h [...]
Number KB0012346
Topic Knowledge Base
Category Best Practice
State Technical Review
Published 2016-03-23

Using values from an excel sheet to calculate different values for further use

This article describes how to get values from an excel sheet (which is not used as a data source for templates) do calculations on those values (specifically ranges) and save them to a buffer for further use. Situation Sometimes, it is not possible to use an excel sheet a [...]
Number KB0012430
Topic Knowledge Base
Category Guide
State Technical Review
Published 2016-05-11

How to verify a interval in TBox

This article shows you the equivalent to {INT[+/-<Interval>]} in TBox Situation By default the function "<Number>{INT[+/-<Interval>]}" is not available for TBox. However, you can use either TBox Evaluation Tool or CALC in combination of IF and AND to ach [...]
Number KB0012804
Topic Knowledge Base
Category Best Practice
State Approval
Published 2017-03-23

Implement a logical time axis (logical business days)

Setting-up a powerful test data management requires to implement a logical time axis, holding the required business days. The days need to be dynamic as well: as time goes by, the 15th of a month will be the 15th of May, the 15th of June, etc.. Your automated test data generator [...]
Number KB0012421
Topic Knowledge Base
Category Best Practice
State Technical Review
Published 2016-05-02

Get Difference between two date time in Hours:Minutes:Second with or without excel installed

This article describes how to get the difference between two Date time (dd MM yy Hours:Minutes:Second) in format "Hours:Minutes:Second" with CALC function and without using CALC. Situation There can be a scenario where you want to find out the difference between DATE [...]
Number KB0014507
Topic Knowledge Base
Category Guide
State Approval
Published

How to get the date of the first Monday of the current week

How to get the date of the first Monday of the current week Situation : Suppose there  is a use case where the user wants to generate the first date of that week (say today is wednesday but the user wants to generate the date correspoinding to Monday i:e, the first day o [...]
Number KB0014696
Topic Knowledge Base
Category Guide
State Approval
Published

Buffer - Convert date

This article shows how to convert a date format, which is stored in a buffer You can convert a date format, which is stored in a buffer, with the help of CALC and TC Set Buffer. For example: {CALC[    TEXT(    "{B[BVVonDate]}"    [...]
Number KB0010879
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2014-07-25

Steering HTML Date Pickers / Calendars without customization

This article explains how to dynamically steer custom HTML Date Pickers (Calendars) using standard Tosca functionalities. We will be using the YUI Simple Calendar for our example but the same concepts can be applied to any HTML Date Picker control. Situation HTML Date Pic [...]
Number KB0012504
Topic Knowledge Base
Category Guide
State Approval
Published 2016-07-06

CONVERT MONTH IN DATE EXPRESSION FROM ONE LANGUAGE TO OTHER

CONVERT MONTH IN DATE EXPRESSION FROM ONE LANGUAGE TO ANOTHER Situation You want to convert month in your Date from one language to another. For example: Actual Date[Swedish]: 14-Mai-19 Expected Date[English]: 14-May-19 Solution You want to convert date fetch [...]
Number KB0014700
Topic Knowledge Base
Category Best Practice
State Approval
Published

HOWTO: Avoid applications like windows calculator popping up in X-Scan under Windows 10

X-Scan seems to pop up applications like calc Situation If you start X-Scan under Windows 10 you might notice that not only the application you want to scan is shown in the x--scan window but a lot of windows (and applications) appear.  This caused by Windows 10 its [...]
Number KB0012935
Topic Knowledge Base
Category Best Practice
State Approval
Published 2017-05-12

Dynamic Expressions: Difference in Translate Value and Output in Engine

This article describes, how complex dynamic expressions can be used in verifications. Situation A complex dynamic expression (most commonly using CALC) gets the correct value when using "Translate Value", but when this expression is used to Verify, it causes an error show [...]
Number KB0011886
Topic Knowledge Base
Category Troubleshooting
State Published
Published 2015-03-20

Reverse a string by using Partial Buffer

This article contains key example when user wants to reverse a string which contains White spaces and any characters. This can be achieved by using TBox Set Buffer and TBox Partial Buffer standard modules. Situation Reverse an input string as below: Input String :&n [...]
Number KB0014601
Topic Knowledge Base
Category Guide
State Approval
Published

How to do Camel Case styling using Tosca

Situation   What to do to convert "TRICENTIS" or "tricentis" to "Tricentis" using Tosca.   Solution   Use Tbox set buffer module, buffer the value "TRICENTIS" to Title. Then with another buffer you can camel case the s [...]
Number KB0014179
Topic Knowledge Base
Category Best Practice
State Approval
Published

Store common strings/words from given two statements/strings in different buffers

Store common strings/words from given two statements/strings in different buffers This article contains key example when user wants to store the common strings/words from 2 different statements in different buffers. Also, User wants to verify the position of the stored string in [...]
Number KB0014272
Topic Knowledge Base
Category Guide
State Approval
Published
Results per page

CALC

&amp;nbsp; When I tried to concatenate 3 strings which have first name, middle name &amp;amp; Last name&amp;nbsp;using CALC,&amp;nbsp;test step is failing. {CALC[CONCATENATE({B[RBWM First Name]},&quot; &amp;quot;,{B[RBWM Middle Name]},&amp;quot; &amp;quot;,{B[RBWM Last Name]})]} when I right click on the value [...]
Author Prudhvi Raju Gurijala
Category Software Testing
Published 2017-04-07

CALC function.

Tosca uses MS office (excel) so it can access the CALC functions. Is there another office apart from Microsoft that Tosca can be configured to use.Saves us buying office licence everytime.It is quite a big dependancy.
Author Ron Kang
Category Great Ideas
Published 2013-03-25

CALC returns string with additional needless blank

Hi, when executing al calc {CALC[TEXT(&quot;&amp;quot;&amp;quot;&amp;quot;{B[MyValue]}&amp;quot;&amp;quot;&amp;quot;&amp;quot;,&amp;quot;&amp;quot;&amp;quot;0000000000&amp;quot;&amp;quot;&amp;quot;)]} I recieve a string with an additional space at the end. e.g. #{CALC[TRIM(TEXT(&amp;quot;&amp;quot;&amp;quot;&amp;quot;123&amp;quot;&amp;quot;&amp;quot;&amp;quot;,&amp;quot [...]
Author Jochen Herrmann
Category Software Testing
Published 2018-09-11

how to calc function with if condition

i am using if condition for get one value which depends on the combination of diffrent values so try the if function as we use in excel with in Calc but is saying that not a valid formula. I tried diffrent below combination. 1.{calc[if({b[a]}=&amp;#39;0&amp;#39;,&amp;#39;Y&amp;#39;,&amp;#39;N&amp;#39; [...]
Author Abhilash Tomar
Category General Discussion
Published 2019-03-22

Error using CALC function. How get the length from a String?

I am trying get the length from a String in a buffer or attribute from TestCaseDesign. I was using this function: {CALC[LEN(&quot;&amp;quot;&amp;quot;{B[Buffer]}&amp;quot;&amp;quot;&amp;quot;)]} and it&amp;#39;s worked for me in the begins, but it is not working with length above 150 characters. Message err [...]
Author Davi Farias
Category General Discussion
Published 2017-09-23

Solution: Get First Value from CSV-List

Thought someone else may also benefit from my efforts: The &quot;ReferenceList&amp;quot; below holds the CSV-list A: Get 1st value from CSV-List: &amp;nbsp; &amp;nbsp; &amp;nbsp;1. -&amp;nbsp; Parameter &amp;gt;&amp;gt; ReferenceText_Temp &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp;- Value&amp;nbsp; &amp;nbsp; &amp;nbsp; &amp;nbsp; [...]
Author Daniel Rykheer
Category General Discussion
Published 2018-10-25

I would like to capture date month, but the zero in the month value will be truncated

Hi, I met an issue but dont know how to solve, appreciate if you can help me, thanks a lot. Purpose: I would like to calculate next month end date of current system date,&amp;nbsp;so i use formula &quot;{CALC[DATE({B[BusndateY]},{B[BusndateM]}+2,0)]}&amp;quot;, the output is 1/31/2018 1 [...]
Author Chen Jenny
Category Software Testing
Published 2018-06-20

Error during evaluation of the expression 'TIMEVALUE({B[CurrentLocalTime]})' with MS-Excel.

Hi, Can i use TBox Set Buffer by using CALC function&amp;nbsp; please find attached screen shot for the same&amp;nbsp; I&amp;#39;m getting the above mentioned error. Regards, Sahithi &amp;nbsp;
Author Sahiti Bolisetti
Category Software Testing
Published 2018-02-27

How to Convert String To Integer.

NewNetDebit=253,512.98 NewNetCredit=-4,256,031.12 Basiclly both are strings. I used these formula {CALC[{B[NewNetDebit]}-{B[NewNetCredit]}]} When i am doing these operaton its showing the below error message. Error during evaluation of the expression &amp;#39;253,512.98--4,256,0 [...]
Author dinesh Gonuguntla
Category Software Testing
Published 2017-09-28

How can i verify preceeding 0's from a buffer ?

I am trying to validate an buffer which holds some numbers as : 12345678, it could also have some value as : 0000012345678, How can i verify that both the values are same ? excluding the 0&amp;#39;s How can i use the CALC method to verify the values ?
Author Bilal Ahmed
Category General Discussion
Published 2017-12-15

Automated Test failure Reporting in TOSCA - Updated

Have you ever wondered if you can make TOSCA report the failed test case to you without you waiting for the execution of all test cases, say you ran a test case on your machine and you stepped out, it would be cool to get an email notification of when a test case fails Wait n [...]
Author Mo Alhashimi
Category Great Ideas
Published 2018-10-18

I want to find whether a date is Sunday or not. I have bufferd the date and am trying to use the ADA

I want to find whether a date is Sunday or not. I have bufferd the date and am trying to use the ADAY to find out if its Sunday or not . First i used the belowin TC Set Buffer to convert to TOSCA date format. {CALC[TEXT(&quot;{B[ProjectStartDate]}&amp;quot;,&amp;quot;dd.MM.yyyy&amp;quot;)]} The [...]
Author Neha Parihar
Category Software Testing
Published 2018-08-24
Tosca Version
Results per page

CALC - More than a little Helper

CALC - More than a little Helper The CALC function is a powerful tool made available to you in Tricentis Tosca. But how can you use it practically? In this article you will learn how to use CALC (even with buffers) for executing both elementary and a many other additional functio [...]
Version 12.2

Perform calculations

Perform calculations To perform calculations in your tests, use the expressions CALC or MATH. Use CALC if you have Microsoft® Excel installed. Use MATH if you do not have Microsoft® Excel installed. Use CALC Use the following syntax for CALC: Syntax: {CALC[&lt;Operand 1&gt;&lt;Operator&gt;&lt;O [...]
Version 12.2

Dynamic expressions

Dynamic expressions Dynamic expressions are used if values are needed for test specification that are not generated until the TestCases have been executed. Dynamic expressions can be used on both the Module and the TestCase level. Examples: the current date the current first of [...]
Version 12.2

Using Buffers: a How-To Guide

Using Buffers: a How-To Guide What exactly is a buffer? Tosca uses the term Buffer to refer to values that can be temporarily saved in Tosca Commander™ and then used again. These values can be either static or dynamic. There are three different ways to buffer values in Tosca: Th [...]
Version 12.2

Settings - Engine Calculator

Settings - Engine Calculator The following setting can be found at Settings-&gt;Engine-&gt;Engine Calculator: Use Excel localization Description This setting is relevant to users of the CALC function (see chapter &quot;Calculations&quot;). Please note that this setting applies only to classic e [...]
Version 12.2
IE BUMPER

Tosca is the perfect solution

Optimize - Manage - Automate

Download Trial