Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I
I'm trying to create a expression to Sum "VolumenReal" with the field PeriodoNumVol having the selection equal to all possible values of the field PeriodoNum.
PeriodoNum and PeriodoNumVol has date values (Year-Month) as this:
201601
201602
201603
201604
My expression (not working) is this:
=Sum( {$<PeriodoNumVol = {">$(=Min(PeriodoNum))<$(=Max(PeriodoNum))"}>} VolumenReal )
Can anybody help me please?
Thanks!
May be this:
=Sum( {$<PeriodoNumVol = {">$(=Date(Min(PeriodoNum), 'YYYYMM'))<$(=Date(Max(PeriodoNum), 'YYYYMM'))"}>} VolumenReal)
May be this:
=Sum( {$<PeriodoNumVol = {">$(=Date(Min(PeriodoNum), 'YYYYMM'))<$(=Date(Max(PeriodoNum), 'YYYYMM'))"}>} VolumenReal)