Dec 22 2020 02:55 AM
Hello Excel community,
I have a column header in excel as
Amount
CashDiscountAmount
CashDiscountDate
CreatedDate
InvoiceDate
DueDate
PostingDate
Vendor name
and I have the data for the respective column.
How do I calculate
Cash Discount utilized (Invoice trasferred before the cashdiscountdate)
Cash discount lost (Invoice trasferred after the cashdiscountdate )
paid late(Invoice posted after due date)
open invoices per vendor
After calculation i need to visualize data ...
Thanks in advance
Bishnu
Helsinki
Dec 22 2020 08:01 AM
You've said After calculation i need to visualize data ...
To which I am going to respond as follows: your inquiry is forcing those of us who might want to help to need to visualize the spreadsheet you're looking at.
Which leads to this question for you: Is it possible for you to help us help you by posting either your actual spreadsheet, if it doesn't include any confidential or proprietary information, or a mockup that substitutes fictional names and data for the real?
Either way, you're far more likely to get a specific and helpful reply if you make it possible for us to actually work with your data or a representation of it. Please, an actual spreadsheet, not just an image.