topic Re: Sum(if( in App Development

Sum(if(

mikegauntlett — Mon, 19 Mar 2018 13:36:51 GMT

Hi Guys,

I have

SUM(IF((IF(IsNull(AARO_Booking_Period) and IsNull(Status),'R0',If (IsNull(Status),'R1',Status)))='R0',1,0))

which sums the total for a set tollgate in this case R0 as underlined.

the R tollgate will either come from the IF statement:

IF(IsNull(AARO_Booking_Period) and IsNull(Status),'R0',If (IsNull(Status),'R1',Status))

or from the Status field itself.

This works for R0 and R1 when I change the underlined but not for any other.

I have tried sum(IF(Status='R2' etc. but this also does not work any Ideas?

As always greatly appreciated.

sunny_talwar — Mon, 19 Mar 2018 13:40:46 GMT

You want to count when Status is R2? May be this

Count({<Status = {'R2'}>}Status)

mikegauntlett — Mon, 19 Mar 2018 13:48:22 GMT

Hi Sunny,

Afraid Not,

so for the 4 possible outcomes R0, R1, R2, R3.

The R0 & R1 will solely come from the IF statement:IF(IsNull(AARO_Booking_Period) and IsNull(Status),'R0',If (IsNull(Status),'R1',Status))

whereas the R2 & R3 will come from the status field which comes from an attached file.

I use the above IF as a master measure 'Master status'

vkish16161 — Mon, 19 Mar 2018 14:29:11 GMT

You can probably look at using the Aggr function

Sum(Aggr(if(condition_true,1,0) , Dimension))

mikegauntlett — Mon, 19 Mar 2018 15:21:16 GMT

Afraid not @Vishnu_Chakravaram