Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
please help me convert the below into set expression
=sum(if(Month(today())=AMonth,(Automated)))
/
sum(if(Month(today())=AMonth,([Total Regression TCs])))
Regards,
Hitha Dhani
SUM({<AMonth = {'$(=Month(Today())))'}>}Automated)/SUM({<AMonth = {'$(=Month(Today())))'}>}[Total RegressionTCs])
SUM({<AMonth = {'$(=Month(Today())))'}>}Automated)/SUM({<AMonth = {'$(=Month(Today())))'}>}[Total RegressionTCs])
thank u this worked.
jus had to remove one bracket )
=SUM({<AMonth = {'$(=Month(Today()))'}>}Automated)
/
SUM({<AMonth = {'$(=Month(Today()))'}>}[Total Regression TCs])