Formula if sum with 2 field conditions

[#1]

Hi guys,

Somebody help me,

How to write the formula if I want to create :

field 'a',  sum({<Year={Max(Year))}, Field_B={'Handphone'}, Field_C={'Komputer'}>} Amount),

how to write with correct formula?

Thanks before

[Anonymous · Accepted solution]

Try this and let me know

sum({$<Year=Max(Year), Field_B={'Handphone'}, Field_C={'Komputer'}>} Amount)

[its_anandrjs]

Try to write like

=Sum( {< Year = {'$(=Max(Year) )' }, Field_B = {'Handphone'}, Field_C = {'Komputer'}>} Amount)

Or

=Sum( {< Year = {"$(=Max(Year) )" }, Field_B = {Handphone}, Field_C = {'Komputer}>} Amount)

[#4]

Great,

Many thanks Mr. Jebamalai Dass