Using as

3.08K viewsFormulas and Functions

I wanna know if there is any possibility to make a formula with a combined of “using as”.

For example. I wanna make in only one formula a “sum” of a column of other matrix but having many conditionals in the same formula.

I´m not sure if the “using as” formula it´s the one that best fits for what I want.

I have attached the example model.



Hello Carlo,

The trick to multiple using as conditions is that you do not repeat the term “using”, you replace it with a comma. If you edit your formula as shown below, you should get the results you want.

using Production order::Product as Products, Production order::Wide as wide, Production order::High as High, Production order::Cloth as Cloth

Kind regards,

Latest Questions

Wrap text in scripted buttons? 1 Answer | 0 Votes
Claculate product 2 Answers | 0 Votes
Sum by group in the same matrix 4 Answers | 0 Votes
Constrain input – varchar 1 Answer | 0 Votes