Forum Discussion

Frequent Visitor

2 years ago

Calculate Overdues based off user entered interval

Hi! So, I am trying to create a report showing the overdues, atm i have manually created for 0-30 days, 31-60 days, ... <360 Days(measures) these are for interval of 30 days. I want to create...

Icon for Solution Sage rank

Solution Sage

2 years ago

Can you provide a sample data in csv format?

Frequent Visitor

2 years ago

amustafa due to restriction i will not be able to do so but here is a sample data

Comp.	Document Type	Document Number	Document Date	Party Code	PartyName	Dept.	Department Name	Balance Amount
001	SIN	IQP1001	4/11/2022	10143	ABC	301	QCC	17.85
001	SIN	IQP1002	10/30/2023	10291	DEF	301	QCC	24.5
001	SIN	IQP1003	9/7/2023	10349	GHI	301	QCC	80.5
001	SIN	IQP1004	10/31/2023	10452	JKL	301	QCC	17.5
001	SIN	IQP1005	11/30/2023	10452	MNO	301	QCC	14
001	SIN	IQP1006	12/30/2023	10452	PQR	301	QCC	5.25
001	SIN	IQP1007	12/26/2023	10476	STU	301	QCC	50.05
001	SIN	IQP1008	11/6/2023	10492	WXY	301	QCC	1.54
001	SIN	IQP1009	12/15/2022	10505	Z	301	QCC	18.9
001	SIN	IQP1010	6/30/2023	10505	SKA	301	QCC	11.34
001	SIN	IQP1011	7/11/2023	10530	IKA	301	QCC	1.4
001	SIN	IQP1012	12/14/2023	10530	PLA	301	QCC	1.4
001	SIN	IQP1013	12/5/2023	10881	OLA	301	QCC	45.5
001	SIN	IQP1014	11/20/2023	10887	UJM	301	QCC	49
001	SIN	IQP1015	12/28/2023	10923	IJB	301	QCC	45.22
001	SIN	IQP1016	12/28/2023	11055	YDC	301	QCC	46.13
001	SIN	IQP1017	11/6/2023	11069	OLQ	301	QCC	18.48
001	SIN	IQP1018	11/6/2023	11069	YTR	301	QCC	18.48
001	SIN	IQP1019	12/7/2023	11147	GHJ	301	QCC	10.5

user_bi
Frequent Visitor
2 years ago
amustafa i seem to have hit a dead end with this query, hope to hear a positive reply from you.

Much appreciated

Related content