Skip to Content

Need help with a WEBI formula

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

Add comment
10|10000 characters needed characters exceeded

  • Follow
  • Get RSS Feed

2 Answers

  • Aug 27, 2018 at 06:59 AM

    Hi Cesar

    Try adding nofilter() in the where clause ie

    WHERE ( NOFILTER ( RELATIVEDAY=..) ).

    Henrik

    Add comment
    10|10000 characters needed characters exceeded

  • Aug 27, 2018 at 04:02 PM

    Try this

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

    Thanks,
    Mahboob Mohammed

    Add comment
    10|10000 characters needed characters exceeded