Display Issue with Formula

NuGenAdmin

I have another equation that is not displaying the value I need to pull down. I think I have the formula right, it's not coming back with an error, yet there is no numbers displaying. Ultimately I want it to pull down the generation from a previous year so wer can compare. Ideas/ Thoughts?

Kelly Moore

Hey @NuGenAdmin

I'm not sure I understand what you're trying to achieve. Try this to see if the guess was correct.

I purposely left off the IFERROR until the formula is working correctly as it will mask any error the formula generates.

=INDEX(COLLECT([Also Energy Production]:[Also Energy Production], Year:Year, [Previous Year]@row, Month:Month, Month@row, [Project Name]:[Project Name], [Project Name]@row),1)

Is this what you need?

Kelly

Kelly Moore

Hey @NuGenAdmin

I'm not sure I understand what you're trying to achieve. Try this to see if the guess was correct.

I purposely left off the IFERROR until the formula is working correctly as it will mask any error the formula generates.

=INDEX(COLLECT([Also Energy Production]:[Also Energy Production], Year:Year, [Previous Year]@row, Month:Month, Month@row, [Project Name]:[Project Name], [Project Name]@row),1)

Is this what you need?

Kelly

NuGenAdmin

@Kelly Moore Thats it!!! Thank you so much!