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)
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?