How to format the "Sum of @Formula" in a cross-tab 1

[sirpelon]

Hi,

I have a cross-tab like this:
Model1 Model2
Concept 1 20.00 5.00
Concept 2 3.00 2.00
Concept 3 10.57 10.23
Concept 4 1.00 9.00

I'll like to know if it is posible to remove the decimals of the concepts 1, 2, 4 and leave them in the concept 3, something like this:

Model1 Model2
Concept 1 20 5
Concept 2 3 2
Concept 3 10.57 10.23
Concept 4 1 9

 

[lbass]

Select the summary->right click->format field->number->customize->decimals->x+2 and enter:

if gridrowcolumnvalue("table.rowfield") = "Concept 3" then 2 else 0

Substitute your row field for "table.rowfield", and remove the curly brackets and replace them with double quotes.

-LB

 

[sirpelon]

Thanks lbass

This really works great!