Hello,
Has anyone encountered issues with the Summation formula when used in Xcelsius. I'm encountering a problem where none of my Xcelsius components are not picking up the Summation cell (example: =sum(A1:A20) ) in preview mode for the selected data coming in. I have exported to excel within preview mode and do see the cell actually does Sum correctly.
I tested hard coded values in Xcelsius then used summation and that works perfectly fine in preview mode. This lead me to believe that maybe the field I was summing was not a numeric field but I checked the universe and the key figure field is set to numeric and all values in the field are numbers.
Please let me know if you have any ideas for this issue.
Thank you in advance,
andy