使用条件计算Crystal Report中的列总和 [英] Calculate Sum of columns in Crystal Report with condition

问题描述

Code Name 01 02 03 04 05...... 31
A001 abc     P   A  P  P  P
B001 xyz     P   P  P  N  A

我想计算员工abc在水晶报告中有多少天，其中粗体文本是我的列名，P是存在A是缺席，N是报告中没有记录（空白）值..



先谢谢

I want to calculate Employee abc is present how many days in crystal report where bold text is my column names and P is Present A is Absent and N is No record (Blank) value in Report..

Thanks in Advance

推荐答案

状态是P / A代替此获取1/0状态（整数值）

现在显示状态它将自动显示状态总和（1 =当前天数）

和现在另一个问题是将0显示为A，将1显示为P...

写一个公式...

status is P/A instead of this fetch 1/0 status (integer value)
Now display status it will show sum of status (1=present days) automatically
and now another problem is to display 0 as "A" and 1 as "P" for this..
write a formula...

iif({status}="0","A","P")

快乐编码！

：）

Happy Coding!
:)

hI CHEETU



将您的公式放在详细信息部分



然后右键单击公式



插入摘要



并将摘要放到报告页脚。



希望这对您有用。

hI CHEETU

place your formula in detail section

then right click on formula

insert summary

and place summary to report footer.

Hope this will work for you.

这篇关于使用条件计算Crystal Report中的列总和的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！