Concatenate formulas

[Anonymous]

Hi,

how  can i concatenate to formulas? First I have if terms, that retrieve value1 without Null. Additional the second value2 should be ingegrated after if()...

=aggr(concat(if(value1='NULL','',value1)), name)

+

value2 = { $(=if (vVariable = 1,'a','b'))}

Regards

Stefan

[swuehl]

Some more details about your data (like INPUT data and your expected results), as well as the context might be helpful.

Maybe like this?

=aggr(concat(if(value1='NULL','',value1 & if(vVariable=1,'a','b') )) , name)

or

=aggr(concat(if(value1='NULL','',value1)) & if(vVariable=1,'a','b') , name)

[Anonymous]

I will attached an example.

[Anonymous]

If you click on ∑ gross  or ∑ net comment should be change

[swuehl]

Ok, but change to what? What is the comment you expect e.g. for Europa or Italien in either case?

[Anonymous]

In dependency of gross / net. Europe with 'gross' have comment: 'EAP...'. Europe with 'net' have comment 'Null'

[swuehl]

This seems to have nothing to do with your original request (concatenation of formulas) and it really would help if you could post some more details about your requirements (well, it's up to you, I am giving up for now).

Here is a solution that fulfills your latest request (though I think it's not really what you want).

[preminqlik]

hi stefen ,

i didnt get you what you exactly mean ...but according to my understanding i have done some changes

please find attchment

regards

Premhas

[Anonymous]

Please find attached the right example.

[Anonymous]

Please find attached the right example.