Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have the following expression :
num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}[Line Total]),'#,###.0%')
I would like to only calculate where the field included_in_analysis='Y' - can anyone advise how can can add this into the above expression please?
Many thanks for you time.
Hi,
num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}, included_in_analysis= {'Y'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}, included_in_analysis= {'Y'} >}[Line Total]),'#,###.0%')
if(included_in_analysis='Y',num(sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}Number)/sum({<MonthYear={'$(=date(monthstart(max(MonthYear)), 'MMM-YY'))'}>}[Line Total]),'#,###.0%'))