Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello Team,
I am trying to fix the below set analysis expression "-=" operator not working.
In expression, I want to filter data related to Due amount as highlighted below
Num(
Sum({<
Cleared_Flag={'Unpaid'},
[%KeyDate]={"$(=max([%KeyDate]))"},
IsDebitor={"$(vDebitorsOnly)"},
[Ev_Overdue.Type]={'Overdue'},
[Ev_Overdue.Bucket]-={'Due'}
>}
[Account_Receivable_Evolution.Amount_$(vCurrency)]
),
'# ##0' & '$(vCurrencySymbol)'
)
This works earlier suddenly stopped working kindly help on this issue.
Thanks for all your responses.
but looks like syntax error in condition so it works for me.
Num(
Sum({<
Cleared_Flag={'Unpaid'},
[%KeyDate]={"$(=max([%KeyDate]))"},
IsDebitor={"$(vDebitorsOnly)"},
[Ev_Overdue.Type]={'Overdue'},
[Ev_Overdue.Bucket]=-{'[Due]'}
>}
[Account_Receivable_Evolution.Amount_$(vCurrency)]
),
'# ##0' & '$(vCurrencySymbol)'
)