I have a requirement where Measure 4 = Measure 3/ Measure 2. When I declare this logic in data action, I can see that logic is working fine for few months
and not for some
. But in yearly view, it is adding up all the ratios and giving me s...
Hi All,
We are preparing a operational plan for our client. In planning process we need count of month. For Example: as we are using fiscal year count for April is 1, for May count is 2 and so on.
Is there any advance formula or any other way we...
Hi Nikhil,I tried your logic by restricting the date column to one year, as it was compounding the total value for all years. But still am getting values, which seem way off than the expected. In the below example, I have narrowed down the logic to j...
Hi Nikhil,Thanks for swift response. Yes, when I use calculated measures, this is working fine. But my requirement is such that, I need to use this measure 3 elsewhere, with year dependency. Example Measure 5 = average of measure 3 values of 2023 an...
Yes , we are also facing the same error in many reports. Wish we had SAC to accept all the excel functionalities in SAP SAC, or have an addin for SAP SAC which can be integrated with Excel and have all the functions such as EPM functions / EVDRE func...
Thank you Nikhil and William for your thoughts.At this point we would want to use the month number as a calculation for generating another output .we tried to model a user-defined time dimension and then added a property as "BASE_PERIOD".We are tryin...
