Field derive from Percentage based on the Date range

[Raggs]

Hello Team,

I need to derive fields from percentage from date range fields. Please find the below given sample data

From date	To date	Percentage
1-1-2019	3-31-2019	7
1-1-2019	12-31-2019	5
1-1-2019	12-31-2019	8
1-1-2019	3-31-2019	7
1-1-2019	12-31-2019	7
1-1-2019	12-31-2019	7
1-1-2019	12-31-2019	3
1-1-2019	3-31-2019	7
1-1-2019	12-31-2019	2.5

and, I need the out as below mentioned. 

From date	To date	Percentage_1
1-1-2019	3-31-2019	7
1-1-2019	3-31-2019	7
1-1-2019	3-31-2019	7

From date	To date	Percentage_2
1-1-2019	12-31-2019	5
1-1-2019	12-31-2019	8
1-1-2019	12-31-2019	7
1-1-2019	12-31-2019	7
1-1-2019	12-31-2019	3
1-1-2019	12-31-2019	2.5

Can you please help me anyone on this ASAP. 

Thanks in advance. 

[Raggs]

I have used the below function however its not working

If(FromDate = '1/1/2019' and ToDate1 = '31/3/2019', Percentage, )   AS   Percentage_1,

If(FromDate = '1/1/2019' and ToDate1 = '31/12/2019', Percentage)   AS   Percentage_2

[Raggs · Accepted solution]

I got the answer for this.  

thank u