I have this formula and is weird is working with some of my apps and other apps not working please help what is happening and formula its on Number payments OnChange here is the formula and screenshot
ForAll(
FirstN(
ColNumb1,
Value(DataCardValue45.Text)
),
Collect(
NewLoansCollection,
{
CItemSerialNumber: Text(Last(NewLoansCollection).CItemSerialNumber + 1),
LoanDueDate: Switch(
DataCardValue40.Selected.Value,
"Weekly",
DateAdd(
DataCardValue39.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0) * 7,
Days
),
"Daily",
DateAdd(
DataCardValue39.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0),
Days
),
"Monthly",
DateAdd(
DataCardValue39.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0),
Months
),
"Annual",
DateAdd(
DataCardValue39.SelectedDate,
Value(Last(NewLoansCollection).CItemSerialNumber + 0),
Years
)
),
Clevel: "",
Ctc: "",
Cdescription: "",
'loan amount': Value(TextInput1.Text) / Value(DataCardValue45.Text)
}
)
)
