on 11-12-2015 5:47 AM
Hi,
I am using Design Studio 1.5 SP1.1 with BEx query as the data source to create an Analysis Application. After exporting the crosstab data to Excel, I am having problem to perform Excel formula on the data cells which are having NULL value.
Example:
As there is no entry in BW infoprovider for Customer 'X' 'Feb-2015' intersection, the sales $ is showing as blank in the report.
When trying to sum the total Sales $ for Feb-2015 using formula "=C3+C4+C5", there is error. But I am able to perform the sum using formula "=SUM(C3:C5)".
The cell's length is zero as shown in below screen shot:
Appreciate if anyone can assist me on this. Thanks.
Hi..I am sending you links on SAP Design Studio. Please Check.
Regards
Saad
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi,
I think it depends what version of Microsoft Excel you are using. In Excel 2013 this issue doesn't occur. However, making use of IFNA function could help you.
=IFNA(C2,0)+C3+C4
You can apply the formula to each cell you want. If it doesn't work try another IF(xxx) formula.
EDIT: or you can make a copy of column C and put this formula:
=IF(LEN(C2)=0,0,C2)
And make the addition with the new column.
Regards,
Bogdan
User | Count |
---|---|
89 | |
10 | |
9 | |
9 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.