Need help with a WEBI formula

[former_member479932]

Hi

I have a table with some vaules, but in one cell i need, the Sum of the day before, how can i do this ?

screen-shot-2018-08-24-at-173013.png

i am trying some like this, but it did't work

please help me

[mhmohammed]

Try this

=Sum([MERMA_U].[Quantity]) Where ([FECHA]=RelativeDate([FECHA];-1))

Thanks,
Mahboob Mohammed

[former_member479932]

Hi Mahboob Mohammed

i tried your formula but it gave me null results

Thanks

[Former Member]

Since the context gives only one day, you need to insert the nofilter operator.

[former_member479932]

Hi Henrik Egedorf but same case, null results.

Thanks

[Former Member]

Hi Cesar

Try adding nofilter() in the where clause ie

WHERE ( NOFILTER ( RELATIVEDAY=..) ).

Henrik