Power Pivot Formula not working

[howard]

I have tried to set up a formula on Sheet4 to compute the Net Value in Col G (it is the value in Col E-Col F eg E2-F2)


it would be appreciated if someone could kindly assist me

Book1
	A	B	C	D	E	F	G
1	Reference	Source	Date	Code	Debit	Credit	Net
2	MR-839	Clothing	10/01/2018	892205		3633.09	3633.09
3	MR-839	Clothing	10/01/2018	892700	3633.09		FALSE
4	MR-839	Clothing	10/01/2018	892205		5790.43	5790.43
5	MR-839	Clothing	10/01/2018	892205		7131.85	7131.85
6	MR-839	Clothing	10/01/2018	892700	5790.43		FALSE
7	MR-839	Clothing	10/01/2018	892710	7131.85		FALSE
8	MR-912	Clothing	10/01/2018	892205		3379.46	3379.46
9	MR-912	Clothing	10/01/2018	892700	3379.46		FALSE
10	MR-867	Clothing	10/01/2018	892205		286.65	286.65
11	MR-8828	Shirts	01/11/2018	892205		13165.42	13165.42
12	MR-8828	Shirts	01/11/2018	892700	13165.42		FALSE
Sheet4

Cell Formulas
Range	Formula
G2	=IF(OR(E2="",F2<>""),F2)

I have also posted yesterday on link below

https://www.excelforum.com/excel-formulas-and-functions/1271509-power-pivot-formula-not-working.html

 

[theBardd]

What does this have to do with Power Pivot?

Shouldn't the formula be AND, plus subtract E2

 =IF(AND(E2="",F2<>""),F2,"")

 

[howard]

Thanks for the help. The data was imported using Power Pivot

 

[theBardd]

So why not add a custom column in Power Pivot?

 

[howard]

I did add a custom column and then set up the formula in the custom column