Forum Discussion
Use previous total with blank cumulative data
I am running aggregate totals based on GL for one of my reports. There is a gap in entries for a few periods where i would like to carry the previous periods amount if there were no transactions that...
amitchandak
Super User
Super UserAnonymous , The FiscalProfilePeriod should be a separate table like the date table. and period on axis should also come from FiscalProfilePeriod
and use all on table in place of table column
filter(all(FiscalProfilePeriod ), <rest of the code >
i figured it out