Forum Discussion

agraca75's avatar
agraca75
Regular Visitor
3 months ago
Solved

Issue with Formulas - When Multiple Rows Similar Rows Exist

Hi - I was wondering if somebody could assist trying to diagnose how I can fix an issue I am having with some data.   I have a file file from a system that has types of absences based on safety inc...
Need Help
  • v-anbandari's avatar
    v-anbandari
    3 months ago

    Hi agraca75   ,

    Thanks for the update.

    To avoid hardcoding and reduce errors, you can use a reference table with From and To dates for each fiscal month. Then, map your data against this table by matching each date to the corresponding From-To range to determine the fiscal month dynamically.

    This approach is easier to maintain, as you only need to update the table when there are changes in the fiscal calendar.

     

    Thank you!

v-anbandari's avatar
v-anbandari
Community Support
3 months ago

Hi agraca75  ,

Could you please confirm if your query has been resolved by the provided solutions? This would be helpful for other members who may encounter similar issues.

 

Thank you.