Crosstab中的Crystal报表运行总计

问题描述

我有一个交叉表:行是日期，colummn是总计，并且是mode(mode1，mode2 ...)
还具有运行累积总计"或运行总计"的功能.
报告会在运行总计中进行正确的计算，但是如果一天中没有值，那么该列(例如，mode2)的运行总计将每天显示0，而该天没有值.但是，如果MODE2之后的任何其他日期都有值，则报告将显示正确的运行总计.
问题是我们不想在运行总计中看到0，而是会看到以前的累积运行总计.
感谢您提供任何建议或任何公式来更正此问题.
谢谢，
例如:
2011年1月1日1 2 3
总计:1 2 3
01/02/2011 5 0 2
总计:6 0 5
01/03/2011:7 1 5
总计:13 5 10

在01/02上，我希望看到运行总数为4而不是0

Hi,
I have a crosstab:rows is date coulumn are total and mode(mode1,mode2...)
also have function to run Cumulative total or running total.
Report do correct calculation in the running total but if one day have no value so the running total for that column (ex, mode2) will show 0 for every day where is no value for that day. But if any other date after the MODE2 has a value the report will show the correct running total.
The problem is we do not want to see 0 in running total rather will see the previous cumulative running totals.
Thanks for any advice or any formula to correct this issue.
Thanks,
ex:
01//01/2011 1 2 3
running total:1 2 3
01/02/2011 5 0 2
running total:6 0 5
01/03/2011 :7 1 5
running total:13 5 10

on 01/02 i want to see the running total as 4 rather than 0

推荐答案

这篇关于Crosstab中的Crystal报表运行总计的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！