Financial Report Designer #value

Hi There

I have made a Financial Report using the Designer.

I ran the Report for 3 years and all of a sudden it gives me a #value.

If I click on the sell it refers to this =GLActualPastel($C$1,$B63,$C$2-1,CurrentPeriodPastel($C$1),,,$C$3)

I presume this is values that comes directly from Pastel, so why will it give me a #value ?

Parents
  • 0

    HI

    Have you checked that all segments of your formula are correct - e.g. $C$2-1 is it reducing what is in C2 by 1 or is the formula looking at C1 instead.  Alternatively, C2 could be formatted as text which would also result in an error.  Without seeing the workbook it would be difficult to determine what is causing the error.

Reply
  • 0

    HI

    Have you checked that all segments of your formula are correct - e.g. $C$2-1 is it reducing what is in C2 by 1 or is the formula looking at C1 instead.  Alternatively, C2 could be formatted as text which would also result in an error.  Without seeing the workbook it would be difficult to determine what is causing the error.

Children
No Data