Sum in straight table

[#1]

Dears ,

Good day , and i hope everyone in good health ,can you find the attached Pic .

i need to do sum on column where the column equal a specific value like what i attached ,

any idea . 

[robert_mika · Accepted solution]

=SUM({<[Rent Type]={'RL'}>} Debtor)

[rajkumarb]

HI Ahmad

Try this in Expression in Straight Table

sum(if(Rent Type<>'RD', Sum Field))

[petter]

You could also jusr simply click iæon the cell with the RL value and it will only show those. Or you could add a list box for the rent type and click on RL in the list box....

[#5]

Yes Raj ,

Thank you for Replay , but i try this but because i have more than two values RD,RL,RM....

thank you