Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi guys
A bit of help needed if I may call on your assistance please?
I am trying to work out a score for the previous FY.
The below works for the current financial year (as an additional request, how do I get this to always to the current year using "Year(Today())")?
( Count({<[FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
/
( Count({<[FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
For the previous financial year, I guess I would need the above (once it's mastered to always be at the current year depending on today's date no matter what Year I select on my app) amending to include "Year(Today())-1"?
Many thanks for your help in advance!
Gareth
Perhaps something like this:
( Count({<MyYearField={$(=Year(Today()))}, [FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
/
( Count({<MyYearField={$(=Year(Today()))}, [FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
Previous year:
( Count({<MyYearField={$(=Year(Today())-1)}, [FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
/
( Count({<MyYearField={$(=Year(Today())-1)}, [FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
Perhaps something like this:
( Count({<MyYearField={$(=Year(Today()))}, [FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
/
( Count({<MyYearField={$(=Year(Today()))}, [FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
Previous year:
( Count({<MyYearField={$(=Year(Today())-1)}, [FTMR_P2P_KPI]={"Success"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
/
( Count({<MyYearField={$(=Year(Today())-1)}, [FTMR_P2P_KPI]={"Success","Failure"},[Purchase Order Document Type - Code]-={''}>} DISTINCT [Invoice Number]))
Thank you very much Gysbert, that worked like an absolute dream.
Thanks again.
Gareth