More calculation functions needed: countif, sumif, iferror etc.
To close gap to Excel and competitor BI tools.
Use case: Liverpool Airport would like a countif function in the formula syntax. This could e.g. be used to calculate the number of months in which an airline didn't cross the limit for load factor.
Especially if it then would be possible to make a condition on dimensions. E.g. countif dimension Month = January or ID = xxx. And if it would then be possible to use a normal if-sentence with a condition on dimensions. E.g. if ID=xxx then yyy.
Please sign in to leave a comment.