Hello v-bofeng-msft,
thanks for replying, and sorry for the delayed answer. I am still checking and refining; have discovered some of my mistakes in forming a formula, ... . I am a bit further.
Could there be a Delegation problem with GroupBy function? Currently when I form a collection I get only 2000 recs in; that's a number I have under Advance settings (and I know there should be more recs). On the other hand I do not get any Delegation warning?
Additionally. If I put
GroupBy(
Filter(
'Activities Days Records',
'Entry Belongs To' = vG_User.'User ID',
),
"cr1db_dateinfocusfilterfield",
"Rest"
)
into a table or collection I get 2.000 recs in.
And if I put the same segment under CountRows(*), I get result 1 (only one rec).
CountRows(GroupBy(
Filter(
'Activities Days Records',
'Entry Belongs To' = vG_User.'User ID',
),
"cr1db_dateinfocusfilterfield",
"Rest"
)
And finally, maybe I should put that at the top :), I have a CDS Custom Entity, each day has more records, which I want to SumUp (e.g., RecordValue) and then count in how many Days the Sum is >0 and in how many Days the Sum is <0.
<= with this I think I already answered myself
But still I would like to have a view into "Rest" inside App. How to do that (If Delegation is not a problem with GroupBy)?
Sorry I know it is a lot but can't gather it otherwise.
Any suggestion, right approach or any hint to my wrongdoing will be much appreciated.
(as you can see, more or less I am a novice)
tnxs
br
@RMC-Pro
