Appended Data Showing in Query View Not In Report

Hi NMC20  - Double-check that your IF statement logic is correctly handling the conditions for both Paypal and Stripe. You may want to add a condition to handle the case where RELATED returns blank

Modified one, you can try below:

% Revenue =
VAR InstallationDate = RELATED('Sites Information'[Installation Date])
VAR ThreeMonthsDate = RELATED('Sites Information'[3 Months Date])
VAR First3MonthsPercentage = RELATED('Sites Information'[First %])
VAR After3MonthsPercentage = RELATED('Sites Information'[3 Months %])
RETURN
IF(
ISBLANK(InstallationDate) || ISBLANK(ThreeMonthsDate) || ISBLANK(First3MonthsPercentage) || ISBLANK(After3MonthsPercentage),
BLANK(), -- or a default value like 0 if needed
IF(
[Date of Order] >= InstallationDate && [Date of Order] < ThreeMonthsDate,
First3MonthsPercentage,
IF(
[Date of Order] >= ThreeMonthsDate,
After3MonthsPercentage,
BLANK()
)
)
)