Skip to Content
0
Dec 08, 2022 at 06:12 PM

Previous Month data based on Input parameter (Current Month) in WEBI Report

105 Views

Hello All,

we have a requirement to build the below logic in Webi Report. Please help me with finding the logic to calculate Amounts for the previous month and year based on input parameter I give like 201908 (Numeric Datatype in the table)

  1. Prompt Date is 8/1/2019 - 8/31/2019 (always run for the month)
  2. Column 1: Date (8/1, 8/2, 8/3, 8/4…8/31)
  3. Column 2: Amount (100, 200, 300,… 1,000)
  4. Column 3: Previous Month Amount (I don’t how to calculate) need help on this
  5. Column 4: same as Column 3 but it need to calculate previous yea

I have used this formula but I am getting data type issue as invalid datatype

=Sum([Amount]) Where (RelativeDate([accounting month];-1;MonthPeriod))

I also have one more dimension with date format field Accntng Mnth Min Date in the table, can this be useful to use in where condition?