Getting zero as display in Design Studio

[Former Member]

I have created a calculated column(attribute) in calculation view in SAP hana (a/b)*100 where a and b are counters from some other calculation view .I want to display this value in my cross tab in Design studio. I am getting values in filter selection but in cross tab the values are zero. I have checked the output in Hana data preview also it's fine but in Design studio cross tab it is showing as zero.Can anyone please suggest me reason for this. Also I am getting an error in log that column storage error attribute engine :divide by zero.

[Former Member]

I want to add a point that when I am using the same formula a/b*100 where I changed 'a' to a calculated column instead of a counter then I am getting the correct output in the cross tab.

[TammyPowlas]

Please share version of Design Studio you are using.  If you are not on 1.6 SP01, consider updating to that version as there are some related notes to this:

https://launchpad.support.sap.com/#/notes/2268514/E

https://launchpad.support.sap.com/#/notes/2256550/E

[Former Member]

I am using 1.6 SP01 version.

[TammyPowlas]

My only other suggestion is this - looks like SAP released SP01 patch level 2 on March 29th (last week) - please download that version and see if it helps

If it does not, then I recommend opening an incident with SAP Support

[Former Member]

Okay thanks