Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Need a filter based on transaction level

Need a filter based on the below sample data, transaction level Please help  
Need Help
amitchandak's avatar
amitchandak
Super User
5 years ago

Anonymous , You can create a new column like

 

Switch( True(),
not(isblank([Debit])) && not(isblank([Debit])) , "CR & DR" ,
(isblank([Debit])) && (isblank([Debit])) , "Zero" ,
not(isblank([Debit])) ,"Only CR",
"Only DR"
)