integral Posted March 9, 2018 Report Share Posted March 9, 2018 Good day. I have a display where I use the Totals & Aggregation Count function to total records. I would like to only display the rows where the total is greater that 1. Caspio expert session indicates that this can be done via Javascript. Any help would be much appreciated, thank you. Colin Hancox Quote Link to comment Share on other sites More sharing options...
MayMusic Posted March 12, 2018 Report Share Posted March 12, 2018 You need to write a custom aggregation with CASE statement for instance: CASE WHEN COUNT(xxxx) > 1 THEN COUNT( xxxx ) ELSE '' END but it will not hide the entire row Quote Link to comment Share on other sites More sharing options...
cheonsa Posted December 23, 2019 Report Share Posted December 23, 2019 Hello @integral, I found a similar post like yours. You may check the solution stated here: -kristina Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.
Note: Your post will require moderator approval before it will be visible.