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.
7
Comments
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.