Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
I need help on below issue where we need data as per below logic
MOM % = (Current month - Previous Month / Previous Month)
Formula: =(Current month – previous month)/previous month%
Month | Bookings | Margin % | Funnel Weighted | Funnel Unweighted | M-O-M % | Y-O-Y% |
Jan | 10 |
|
|
| 10 | |
Feb | 15 |
|
|
| 50% | |
Mar | 25 |
|
|
| 67% | |
Apr | 30 |
|
|
| 20% | |
May | 10 |
|
|
| -67% |
for this when we are using below formaulae we are receving July month data which actually we should not be there aswe are in June
=if(Month = 'Jan',sum({<Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate),
(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}
,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate))
-
(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}
,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate)))
/
(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}
,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate))))
jan | 18736 |
feb | 18417 |
mar | 36099 |
april | 31215 |
may | 24317 |
jun | 7160 |
jul | 100 |
Thanks in Advance!
Timba!
May be this:
=if(Month = 'Jan',sum({<Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate),
If(Above(Sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}, Stage={'S'}, [Interco Flag]={'External'}>}[Booking Amount Euros] * Rate)) > 0,
(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}
,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate))
-
(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}
,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate)))
/
(Above(sum({<vCalendar = {">=$(=MonthStart(Today()))<= $(=MonthEnd(Today()-1))"}
,Stage={'S'},[Interco Flag]={'External'}>}[Booking Amount Euros]* Rate)))))