Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I need to put the below logic together.How can I do that please ?
Building ID | Occupancy Count | Building Capacity | Occupancy Count (manual) | Building Capacity (manual) |
THOM-B0843 | 0 | 2 | 0 | 0 |
BUCHAREST | 0 | 1 | 0 | 0 |
THOM-B5661 | 0 | 256 | 0 | 0 |
BLACKWALL | 0 | 1 | 0 | 0 |
THOM-B0150-M | 0 | 2 | 0 | 0 |
THOM-B5631 | 0 | 35 | 0 | 0 |
KUWAIT | 0 | 14 | 0 | 0 |
THOM-B4032 | 0 | 6 | 0 | 0 |
THOM-B5262 | 0 | 96 | 0 | 0 |
SAUCES | 0 | 22 | 0 | 0 |
THOM-1234 | 0 | 34 | 67 | 100 |
THOM-3218 | 0 | 45 | 67 | 108 |
if ([Occupancy count] =0 ,
if([Building Capacity] > 1 , sum([Building Capacity(Manual)]
the tricky part is if the first rule is true and
if([Building Capacity(Manual)] =0 ,
if([Occupancy Count(Manual)]=0,sum([Building Capacity]
Thanks much,
Alva
Do you want expression like this
=if ([Occupancy Count]=0 and [Building Capacity (manual)] =0 and [Occupancy Count (manual)]=0,sum([Building Capacity]),
if ([Occupancy Count] <>0 and [Building Capacity] > 1 , sum([Building Capacity (manual)])))
or can elaborate your requirement more with example
Hi Pavana:
May be this will work
If([Occupancy Count]=0 and [Building Capacity(Manual)] = 0 and [Occupancy Count(Manual)] = 0, Sum([Building Capacity]),
If ([Occupancy Count]=0 and [Building Capacity]>1), Sum([Building Capacity(Manual)]))
Hi Pavana:
You can try this if the first one doesn't work
If([Occupancy Count]=0 and [Building Capacity(Manual)] = 0 and [Occupancy Count(Manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),
If ([Occupancy Count]=0 and [Building Capacity]>1), Sum([Building Capacity(Manual)])
there few brackets are missing. Check this now,
=If([Occupancy Count]=0 and [Building Capacity (manual)] = 0 and [Occupancy Count (manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),
If([Occupancy Count]=0 and [Building Capacity]>1, Sum([Building Capacity (manual)])))
This works for me.
Many thanks Mayuresh.
Apologies for the mistake. Just copying from Mayuresh:
=If([Occupancy Count]=0 and [Building Capacity (manual)] = 0 and [Occupancy Count (manual)] = 0 and [Building Capacity]<2, Sum([Building Capacity]),
If([Occupancy Count]=0 and [Building Capacity]>1, Sum([Building Capacity (manual)])))
Try like this
if ([Occupancy count] =0 and [Building Capacity] > 1 and [Building Capacity(Manual)] =0 and [Occupancy Count(Manual)]=0, sum([Building Capacity(Manual)],
if([Building Capacity(Manual)] =0 and [Occupancy Count(Manual)]=0,sum([Building Capacity]
)
)