Please help,
I’m trying to make a payment formula, with several months of payment criteria and generate a list of each payment value each month.
the results I now get, only 1 value and does not display the value of the selection of several months.
To clarify what I mean, here’s a photo.
I wonder if including [_THISROW] might not be the problem. I have done something similar in an app of mine. I wanted to make a list of items from the whole table so I didn’t use [_THISROW]. Is the data that you want in other rows?
P.S. If you could provide higher quality screenshots in the future, that would be nice. This was hard to read.
I would guess your Valid If expression isn’t working as you intend.
First recomendation: if you need table-presentation of data read
Second recomendation: if you prefer “visual” representation of your data try charts
yes, you are right @steve.
I want to count the sum of an enumlist column with certain criteria.
in this case I have a column for the month of payment, if I only count how many months, of course it is very easy. but when I only want to calculate the monthly payment column with certain criteria, for example
Monthly Payment: Jan, Feb, Mar
Count[Month Payment]
But, if one of the criteria is included in the monthly payment, how do I make the formula? for example, only counting 1 or 2 months, because the remaining 1 month does not fit the criteria
Pretty straight-forward:
COUNT(
FILTER(
"table",
criteria-expression
)
)
With appropriate substitutions for table and criteria-expression.
thanks @steve,
but I can’t use the formula, I don’t know where the error is or maybe there is a missing expression.
and finally i found another way, but it might be a bit troublesome, because i have to create some virtual columns for help ,to get the result i want