Expression Help

[Anonymous]

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

[Gysbert_Wassenaar · Accepted solution]

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]))

[Anonymous]

Thank you very much Gysbert, that worked like an absolute dream.

Thanks again.

Gareth