How to print parameter start financial period in the ARM. for example when i run this report, report parameter financial period is 09-2023, then i want to print 09 as value in the column set. i’ve tried different formula, but it didn’t work. i’ve added ARM report xml file in attachment.
Best answer by aaghaei
try
=CInt(Replace(Trim(Substring(@StartPeriod, 0, 2)), '-', ''))
+19Hello,
This formula worked for me in Demo.
=Left(Report.FormatPeriod(@StartPeriod, -2),2)
Hi
Thanks for your quick respond to my post. appreciate your help.
Actually i want to add a calculative field (YTD/End period) to calculate monthly average spend. but in this case when i added your formula in below section then it’s giving error.
+10try
=CInt(Replace(Trim(Substring(@StartPeriod, 0, 2)), '-', ''))
+10Sorry, I missed the second request. In your case, if you want to get avg monthly Actual YTD then try:
=F/CInt(Replace(Trim(Substring(@StartPeriod, 0, 2)), '-', ''))
But I guess you should be going by @EndPeriod, not the Start Period.
Hi
Thanks a lot for your help.
really appreciate your help.
Now this has been solved after adding below formula in the column set and now it’s correctly printing startperiod value based on the period selected in the parameter and then i used another calculation to print average month spend, which is (YTD Actual / Start period value).
=CInt(Trim(Left(Report.FormatPeriod(@StartPeriod, ), 2)))
+10Glad you could make it work.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.
