0

Condition where

Hi again. I am still trying to get my head around conditions in Ninox. I have a field (sum from another table) where I would like to restrict which numbers are being added in the sum. Normally I would use "select x if" "or select x when y is z" but I'm struugling with these conditions.
I have table E. E shall sum amounts from P. P is a many table referenced from Y. I would like for my field i E to be sum(P.xx)when Y=zz. If/else doesn't work because I have both zz and yy in Y.

2 replies

null
    • Choices_Software_Dean
    • 4 yrs ago
    • Reported - view

    Would filtering using "where" help? Below is an example from documentation:

     

    sum((Invoice where Status = 2).Amount)
    sum(Invoice[Status = 2].Amount)

    • -
    • silver_bee
    • 4 yrs ago
    • Reported - view

    Thanks very much , Dean. 
    Yes; sum(Invoice[Status = 2].Amount) worked like a charm!

Login to reply

Content aside

  • 4 yrs agoLast active
  • 2Replies
  • 564Views