Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
@Alessandro_TZ9
see this Alt() to add to the missing value 0:
Measure:
Alt(YourExpression,0)
- Matheus