About HoScho

HoScho · 11-20-2022

Hallo everybody!If got a column "Name" an a column "DateTraining" Name101.01.2022Name202.02.2022.Name103.03.2022Name204.04.2022Name310.10.2021The Return has to look like this: (show the LatestDate of DateTraining)Name103.03.2022Name204.04.2022Name310...

HoScho · 05-19-2021

I have a “valid if” condition whether a customer number exists. It works for a new entry but not when I edit the row. What can i do? NOT(IN([KdNr] , kunden[KdNr]))

HoScho · 10-31-2020

I have a column with an invoice date. I only want to see the invoices that were created on a selectable day. How can I do that. many thanks

HoScho · 03-19-2019

Result[ActiveRow(X)column(Z)= value[ActiveRow(X)column(Y)] - value[ActiveRow(X-1)column(Y)] (XY) (XZ) 100 0 (100-0=0) 120 20 (120-100=20) 110 -10 (110-120=-10) 130 20 (130-110=20) 100 -30 (100-130=-30)

HoScho · 11-21-2022

I have now found the reason for the error.orderby expects a KeyValue as the first argument.But I can't set "Name" as a KeyValue. For me, this is the "Timestamp" column.Any idea how I can solve this?

HoScho · 11-20-2022

Thanks for the very good Video, butindex(orderby([Name],[DateTraining], true),1)return a Error "ORDERBY has invalid inputs"

HoScho · 05-19-2021

Thanks a lot!

HoScho · 03-19-2019

Yes, that’s what i want

My Stats

HoScho's Bio

Badges HoScho Earned

Recent Activity

select last date without duplicates

Valid If - for existing row

Dynamic filter selection

How can I get the difference of values from different rows

Re: select last date without duplicates

Re: select last date without duplicates

Re: Valid If - for existing row

Re: How can I get the difference of values from different rows