Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Try this and let me know
sum({$<Year=Max(Year), Field_B={'Handphone'}, Field_C={'Komputer'}>} Amount)
Try this and let me know
sum({$<Year=Max(Year), Field_B={'Handphone'}, Field_C={'Komputer'}>} Amount)
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)
Great,
Many thanks Mr. Jebamalai Dass