Skip to Content
0

How to add calculation in cross tab report ?

Jul 11, 2017 at 05:44 PM

39

avatar image

Dear Experts,

In Crosstab report, I want to add 2 more summarized filed, where it's a calculation part to show percentage value. I tried various formula to get a solution but unfortunately, it does not work for me.

Please check attached image, In 3rd Summarized field I want to display 30% of the 1st field value, and in 4th summarized field I want to display (2nd field value / 3rd field value *100)

Also in Report, 2nd summarized filed is a formula column

Accomploished : if {@Date_Diff} = 0 then 1 else 0

Date_Diff ->

if isnull ({incident.resolved_at}) then datediff ("d", {incident.opened_at},CurrentDateTime ) else DateDiff ("d",{incident.opened_at} , {incident.resolved_at}) .

Could you please help me to add calculation part in cross tab report .

calculation.jpg (229.9 kB)
reports.jpg (206.3 kB)
10 |10000 characters needed characters left characters exceeded
* Please Login or Register to Answer, Follow or Comment.

1 Answer

sriram santharaman Jul 12, 2017 at 11:26 AM
0

Dear Experts,

Using Insert Embedded summary option, I added 3rd and 4th filed as per calculation required for the report.

But I want to display only the 4th Filed in Report If I remove the summarized field, then the grid value throwing an error.

Is It possible to do,Else is there any other alternate wat to do this instead of using embedded summary, Please suggest.

3rd Summarized filed: if GridValueAt (CurrentRowIndex, CurrentColumnIndex ,0 ) =0 then 0 else round((GridValueAt (CurrentRowIndex, CurrentColumnIndex ,0 ) / 100) * 30 )

4th Summarized field: if GridValueAt (CurrentRowIndex, CurrentColumnIndex ,1 ) = 0 or GridValueAt (CurrentRowIndex, CurrentColumnIndex ,2 ) = 0 then 0 else (GridValueAt (CurrentRowIndex, CurrentColumnIndex ,1 )/GridValueAt (CurrentRowIndex, CurrentColumnIndex ,2 )) * 100


reportss.jpg (268.3 kB)
Share
10 |10000 characters needed characters left characters exceeded