AnsweredAssumed Answered

Counting records depending on 2 fields in a calculation

Question asked by yodavish on Sep 7, 2017
Latest reply on Sep 7, 2017 by Jason Wood

Hello FM Community,

 

I'm trying to get a ValueCount of records from the same table "BillingEvent", if BilledFlag = "No" and if Active = "Yes". I can get the calculation to work by using only one condition but not both using this calculation below:

 

 

Let ([rows = ValueCount ( FilterValues ( List ( BillingEvent::BilledFlag ) ; "No"))

 

] ;

 

"Billing Events" & Case ( rows = 0; ""; " (" & rows) &

Case ( rows = 0 ; ""; rows = 1; " item)" ; " items)" )

)

 

Any help would be great thanks!

 

David

Outcomes