Filling missing Year-Month rows on a Table (no script)

Alessandro_TZ9 — Wed, 24 Jul 2024 15:15:22 GMT

Hello,

I need to fill the rows of a straight table with missed year-months, due of zero values.

For some reasons I cannot modify the script, so I must find a front end solution.

Below an example (good case):

Right case

Below a bad case, to be corrected filling the missing year-month rows with zero:

The 1st column formula:

" =Dual(Year([acq.ba-dboll])&'-'&Month([acq.ba-dboll]),MonthStart([acq.ba-dboll])) "

" [acq.ba-dboll] " is the Date field.

Any ideas? Thanks for helping

Alex

Re: Filling missing Year-Month rows on a Table (no script)

MatheusC — Thu, 25 Jul 2024 20:52:24 GMT

@Alessandro_TZ9

see this Alt() to add to the missing value 0:

Measure:
Alt(YourExpression,0)

- Matheus