Forum Discussion
Sai_Alkesh
Helper II
Helper IILast 12 Months (LTM) Operating Profit Calculation Measure
Hello Experts, Appreciate your help on creating a measure to calcuate the last twelve months (LTM) of core operating profit. Below is the table with data and how it is being calculated in Excel. FY ...
Sai_AlkeshHelper II
Helper IIHello daXtreme
Sorry, if the logic is not clear. What i wish to accomplish is to get Core operating profit for the period September 2022, based on the following formula :
Value from Fiscal year end (march month) - value from September 2021 + value from September 2022.
based on the selection, the measure should calculate the operating profit for the selected period.
please do let me know, if this is still not clear and i will do a detailed write up.
thank you.