Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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 .
=SUM({<[Rent Type]={'RL'}>} Debtor)
=SUM({<[Rent Type]={'RL'}>} Debtor)
HI Ahmad
Try this in Expression in Straight Table
sum(if(Rent Type<>'RD', Sum Field))
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....
Yes Raj ,
Thank you for Replay , but i try this but because i have more than two values RD,RL,RM....
thank you