Jump to content
Changes to the Jaspersoft community edition download ×

group count?


cactusbeef

Recommended Posts

$V{Group1_COUNT}>=$F{SUM_COUNT}

 

1) I have a Group1 with Expression as $F{SCH_ID} , so I can display the Group1_COUNT 

2) also in my sql I have someting sum (1) OVER (PARTITION BY SCH_NUM, LOC_NUM) AS SUM_COUNT,

 

3) $V{Group1_COUNT}==$F{SUM_COUNT}?  "Total  :  "+$F{SUM_COUNT} : "" 

4) in my testing example, 

the last row, the display of both  Group1_COUNT and  $F{SUM_COUNT} all 98 , but just can not hit the equals part ? why

Link to comment
Share on other sites

  • Replies 0
  • Created
  • Last Reply

Top Posters In This Topic

Popular Days

Top Posters In This Topic

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...