1. TARGIT Community
  2. Community
  3. Feature requests / Ideas
Knowledge Base

More calculation functions needed: countif, sumif, iferror etc.

Ole Dyring ·

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.

19

Comments

1 comment
Sort by DateVotes
  • Louise Stub Hansen

    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. 

    5
Please sign in to leave a comment.