Jump to content
Changes to the Jaspersoft community edition download ×

calculation in crosstab cell?


2006 IR Open Dicussion

Recommended Posts

By: harvestmoon1200 - harvestmoon1200

calculation in crosstab cell?

2006-03-07 22:51

is it posible to do calculation in a text field in crosstab?

 

 

 

 

By: cardondenis - cardondenis

RE: calculation in crosstab cell?

2006-03-08 00:23

you can do calculation through the "crosstab" tab, like multiplication, string concatenation, etc. However I'm not sure which field/variable can be used further than the one set up in the crosstab properties/edit crosstab properties/measures.

 

Cheers,

 

Denis

 

 

 

 

By: harvestmoon1200 - harvestmoon1200

RE: calculation in crosstab cell?

2006-03-09 01:21

However, we can put any type of variable into a String text field.

 

 

 

 

By: harvestmoon1200 - harvestmoon1200

RE: calculation in crosstab cell?

2006-03-09 01:09

Dear Denis,

 

thanks for the suggestion. I have try this before. but it seems that we can't do things like change the type of a figure from long to double or to integer in the text field in crosstab's tab.

 

Besides that, we also cannot do calculation, NOT EVEN FOR SAME TYPE fields/ variable..

 

 

 

 

 

 

By: cardondenis - cardondenis

RE: calculation in crosstab cell?

2006-03-09 01:35

Hi harvestmoon,

 

Here is an example of crosstab textfield expression:

 

$V{valeur_Nothing}.doubleValue()!=-1 ?

"" + $V{valeur_Nothing} : "A"

 

valeur_Nothing is a Double, and the result is a String. I've not try though with more than one measure.

 

Cheers,

 

Denis

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

Popular Days

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now

×
×
  • Create New...