Hi,
I am facing issue in trying to reference the same item of prev row. For example,
This is the Excel formula for a line item ‘Calendar Month’ :
IF Calendar month of prev row = 12 THEN 1 ELSE Calendar month of prev row + 1
Has anyone faced similar issue? The Else part of the formula gives circular reference.
I have Month No. as my row, trying to apply formula for Calendar month line item
PFB the Screenshot :
Thank you. I was able to resolve the functions for Month/Year related line items using Cumulative.
But I have similar issues with other line items too, where we cannot use Cumulate() or Mod().
For Example:
These items are dependent on each other, hence giving circular reference
Any workaround for this?
As per my understanding , use the cumulate function - the Boolean line item used to reset the start month
Cumulate(Month No, boolean)
find the attachment for your reference