Formula not working

[danialier]

Hello,

Any idea why this formula is not working ?

  =num(sum({<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#=max(Month#)>}Units),'#,##0')

thks,dani

[MK_QSL · Accepted solution]

=num(sum({<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#= {‘$(= max(Month#))’}>}Units),'#,##0')

[Colin-Albert]

Can you test that max(Month#) returns a valid value?

Is the case of 'Lseries' correct? Could it be 'LSeries' perhaps?

[#4]

  =num(sum({<[Product Line]={'Hardware'},Measure={'CI'},Category={'Lseries'},Month#={'$(=max(Month#))'}>}Units),'#,##0')

[danialier]

cool !