Skip to Content
avatar image
Former Member

How to add calculation in cross tab report ?

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)
Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

1 Answer

  • avatar image
    Former Member
    Jul 12, 2017 at 11:26 AM

    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

    Add comment
    10|10000 characters needed characters exceeded