Condition

[dseelam]

Hello All,

Attached files has item types with Demand and ONHAND, I am trying to get active, slow moving and obsolete item types

I need

sum(if(DMND>0,(DMND>ON_HAND),ON_HAND)) //////////active

sum(if(DMND<>0,(ON_HAND>-DMND),HAND)) ////////////////////slow

sum(if(DMND=0,ON_HAND>DMND,ON_HAND)) //////////////////////obs

but where ever ONHAND is '0'its giving me -1 which is wrong is there any other way to do it ?

Thanks,

D

[Anil_Babu_Samineni]

May be this?

If(DMND > ON_HAND, Sum(ON_HAND))

[dseelam]

Thanks anil

How to include other condition DMND should be always >0

[Anil_Babu_Samineni · Accepted solution]

This condition should work

If(DMND > ON_HAND and DMND >0 and DMND <>0 , If(ON_HAND>DMND,Sum(ON_HAND)))

From your data, you may don;t have ON_HAND values > DMND Values. For this you can check. Whether you have value or it showing all "There are no Exceed"

If(DMND > ON_HAND and DMND >0 and DMND <>0 , If(ON_HAND>DMND,Sum(ON_HAND),'There are no Exceed'))