Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Friends
I have following expression which is incorrect
sum({<NOs={">=0" OR {'A'}>}rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))
I want to range sum given fields if Nos>=0 or Nos=A
Pls help to correct my expression
sum({<NOs={">=0"} + {'A'} >} rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))
sum({<NOs={">=0"}> +<NOs = {'A'}>}rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))
sum({<NOs={">=0"} + {'A'} >} rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))
Thanks
It works following way also
sum({<NOs={">=0","A"}>}rangesum(CL_PROV,+CL_ADJUS,-RE_PROV,-SALVAGE))