Hello,
I want to add an excel formula as a text string in business objects.
I have three columns that I want to read as an excel formula so once it is exported, the individual would just change the columns to General and then hit F2 and enter for the formula to work.
Is this possible?
MHamid (BOB member since 2016-06-24)
Yes, it’s possible. Just add ="=the formula" into the column you want to use for the formula remembering to include the double quotes and the =.
However, this only works while the column layout remains the same - so if somebody adds an additional column to your output or reorders the columns, the formula may well break.
I have used this in the past, but it’s not something I do very often - and only on reports that are only used by me not by other users.
Maddye 
(BOB member since 2009-01-09)
Hello,
Thank you, but it did not work for my formula since there is a part of the formula with quotations already. Below is the formula I want as a text.
=IF(L2=“individual”,CONCATENATE(F2,N2,P2,O2,W2,Y2,Z2),CONCATENATE(F2,Q2,W2,Y2,Z2))
Trying the way you suggested brought back the error message “Invalid identifier ‘individual’ at position 11. (IES 10022)”.
Any other suggestions to get this formula as a text?
MHamid (BOB member since 2016-06-24)
OK, try without the first = the one outside the double quotes.
Is there a reason you don’t do the calculation within BO? You would have to stack the concatenations two by two, so the first one would start off (adding each object in turn)
concatenation(O2, concatenation( the object corresponding to W2,(concatenation( the object corresponding to Y2, the object corresponding to Z2))) etc
That would mean any change to the output layout won’t affect the result.
Maddye (BOB member since 2009-01-09)
This works in Webi:
="=IF(L2="+Char(34)+"individual"+Char(34)+",CONCATENATE(F2,N2,P2,O2,W2,Y2,Z2),CONCATENATE(F2,Q2,W2,Y2,Z2))"You might need to use & instead of + in Deski, I can’t remember because I’ve not used it for a few years.
Hello,
Mark, I used your formula and it works beautifully. Thank you soooo much.
Maddye, I could not get yours to work for me, but I really do appreciate all of your help. Thank you soooo much.
MHamid (BOB member since 2016-06-24)