PY MTD.

Vikas Bhorhari shared this question 3 years ago
Answered

How to Calculate PY MTD.

Comments (2)

photo
1

Hi Vikas,

Thanks for reaching out. The only way to accomplish this is to write a custom SQL CASE statement and add it to the custom-functions.xml file, located in <YellowfinInstall>/appserver/webapps/ROOT/WEB-INF.

The actual scripting of this is outside the scope of report, but there's some more information and guidelines on creating Custom Functions from our Wiki page: http://wiki.yellowfin.com.au/display/USER72/Custom+Functions

To then use the created Custom Function in a report, you'd create a Calculated Field, select Pre-Defined Formula Type, and the new function should then appear in the dropdown, if scripted correctly:

/nBMxAggggAACCCCAAALGCPwHE0wkbyIhQ40AAAAASUVORK5CYII=

Hopefully this helps!

Regards,

Mike

photo
1

Hi Vikas,

I'm going to go ahead and mark this one as Answered since I haven't heard back from you in a couple weeks, but if you have further questions or concerns on this, if you respond, it will re-open the case and put it back in my queue and I'll be happy to help.

Regards,

Mike