Chose Specific file for end of the month reconciliation

[kauser]

Hello,

currently i am working in a file where there is a specific cell that should have balance only for last day of month reconciliation and for rest of the days should be blank. is there any way i can mapped that cell only for last day of the month reconciliation and rest of days from the month should be blank. please advice. 

thank you 

kauser 

[binuacs]

@kauser Can you provide a sample input file and expected output for a better understanding of your requirement?

[kauser]

Hi @binuacs 

Thanks for your message. unfortunately my company won't allow to upload any files in this site. here i am trying to illustrate the scenario 

July 31st reconciliation 

Item	Amount
A	$50
B	$40
C	$20
V	$65

all these items from A-C are coming from same file during the month except Item V which need to populate only last business day of the month and rest of the days Item V should be blank(see below).  

July 30rd reconciliation 

Item	Amount
A	$50
B	$40
C	$20
V	$0

[Yoshiro_Fujimori · Accepted solution]

Hi @kauser ,

If you just replace the cell for Item "V" on the last "calendar" day of the month, this formula would work.

Amount = 

  IF [Item] = "V" AND DateTimeToday() = ToDate(DateTimeLastOfMonth())
  THEN 0
  ELSE [Amount]
  ENDIF

However, if you want to use the last "business" day in the condition,

you would need to have another table to know the last business day of each month.

I attach a sample workflow for your reference.

I hope this helps.

Good luck.