# Incompatibility The Text() and Fixed() with the Join()

Hi all,

Trial testing QM5.3.7 showed the incompatibility of text functions: Text(), Fixed() and Join().

Briefly the essence of the problem.

1. Model’s Objective: To generate a string with the cost calculation according to **Buy**, **Sell** and **Quota** datas like a **ToBe**. See attachment.

2. The study was performed in a test version of QM5.3.7

Result.

**AsIs1** is calculated corrrectly by the formula №1 of **Text Functions Probing** matrix, but it does not format ALL numbers.

Therefore, attempts were made using text functions Text() and Fixed() to make numbers formatting in the format I need (**ToBe**). See formulas [2 .. 5].

As can be seen, the use of these functions has not led to the desired result entirely. These functions do not work together in this task.

===

Unlike QM, Excel perfectly copes with a similar calculating task.

Hi all,

FYI. The QM’s Char(), Dollar(), Fixed(), Roman() and Text() functions can’t return a lists of values to the Join(). This is the reason why the formulas [2..5] do not form a correct results.

To work around this limitation, it is necessary to broaden the structure of the model and separately run numbers formatting.