Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
How to get a value with max month and another criteria as below?
=sum(if([CPR_TM1_202202.MONTH]= '2/1/2022' and [CPR_TM1_202202.Business]='CMB', [CPR_TM1_202202.amount]/1000000000))
2/1/2022 is max date in my data set. I want to change '2/1/2022' using the MAX function
any idea?
ahhh i seee.
really appreciate all solutions from you!
thank you Vitalli!
Regards,
Daniel
Welcome! If it's possible please mark correct answers as "solutions".