Hello,
I have a dataset with 2 columns:
- dtLastIncident : a date
- dSinceLast : a formula that count the days between CURRENT_DATE and dtLastIncident
This was created from a tutorial and work great. I can see all the rows that I have created and sort them to display the data in template.
I want to add the number of incident since the beginning of current year and maybe total number of incident, so I created 2 others columns:
- dCountInYear : COUNT(CASE WHEN YEAR(dtLastIncident)=YEAR(CURRENT_DATE) THEN 1 ELSE NULL END)
- dCountTotal: COUNT(*)
But with these columns (or one of these), the columns are right calculated, but the dataset is only showing the first row. When I add a row, I can only see the counts update, but still one row with dtLastIncident and dSinceLast of the first row. If I remove these columns, I can see all the rows, even the rows created with actives count columns.
Since column dSinceLast is a formula, it is not a problem with formula column, but is there a problem with count statement in a formula column?
Before column creation:
After column creation:
After adding a new row:
After removing the count columns:
Thanks in advance
CMS Version
4.2.3
Player Type
Android players