Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
I will attached an example.
If you click on ∑ gross or ∑ net comment should be change
Ok, but change to what? What is the comment you expect e.g. for Europa or Italien in either case?
In dependency of gross / net. Europe with 'gross' have comment: 'EAP...'. Europe with 'net' have comment 'Null'
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).
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
Please find attached the right example.
Please find attached the right example.