Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
Selecting a month and using this expression:
SUM({<DAY={"$(=timestamp(Addmonths(only(DAY),-1)))"}NET_PRICE)
/ SUM({<DAY={"$(=timestamp(addyears(Addmonths(only(DAY),-1),-1)))"},STATUS={'CONTRACT'},IS_MERCHANT={'Y'}>}NET_PRICE)*
SUM({<DAY={"$(=timestamp(addyears(only(DAY),-1)))"},STATUS={'CONTRACT'},IS_MERCHANT={'Y'}>}NET_PRICE)
How can I show the result for each day of the month selected??
regards!