topic Re: Condition not working in Management & Governance

Condition not working

zied_ahmed1 — Thu, 23 Mar 2017 08:03:04 GMT

Hello,

I have this condition and it works :

sum( {<[Month of date]= >}

if( Pays='Maroc',

aggr(

if (Only({<[Month of date]>}Code_Ligne)='MAR',

(

Count({<$(vSetPeriodRange),Code_Ligne={'MAR'}, [Month of date]=,Flag_Doublon={1}>}Dossier)

)

Count({<$(vSetPeriodRange),Code_Ligne={'MAR'},[Month of date]=,Timeframe=,Flag_Doublon={0}>}Dossier)

Count({<$(vSetPeriodRange), [Month of date]=>}Dossier))

, Pays, [Month of date]),

aggr(Count({<$(vSetPeriodRange), [Month of date]=>}Dossier)

,Pays, [Month of date])

)

But when i want to delete the condition if( Pays='Maroc', it doesn't work :

sum( {<[Month of date]= >}

if (Only({<[Month of date]>}Code_Ligne)='MAR',

aggr(

(

Count({<$(vSetPeriodRange),Code_Ligne={'MAR'}, [Month of date]=,Flag_Doublon={1}>}Dossier)

)

Count({<$(vSetPeriodRange),Code_Ligne={'MAR'},[Month of date]=,Timeframe=,Flag_Doublon={0}>}Dossier)

Count({<$(vSetPeriodRange), [Month of date]=>}Dossier)

, Pays, [Month of date]),

aggr(Count({<$(vSetPeriodRange), [Month of date]=>}Dossier)

,Pays, [Month of date])

)

Thank you

Re: Condition not working

sunny_talwar — Thu, 23 Mar 2017 09:22:22 GMT

If you are removing the if condition, then remove the true or false condition also... try this

sum( {<[Month of date]= >}

if (Only({<[Month of date]>}Code_Ligne)='MAR',

aggr(

(

Count({<$(vSetPeriodRange),Code_Ligne={'MAR'}, [Month of date]=,Flag_Doublon={1}>}Dossier)

)

Count({<$(vSetPeriodRange),Code_Ligne={'MAR'},[Month of date]=,Timeframe=,Flag_Doublon={0}>}Dossier)

Count({<$(vSetPeriodRange), [Month of date]=>}Dossier)

, Pays, [Month of date]),

aggr(Count({<$(vSetPeriodRange), [Month of date]=>}Dossier)

,Pays, [Month of date])

)

Re: Condition not working

zied_ahmed1 — Thu, 23 Mar 2017 09:30:24 GMT

the problem is not solved yet when i remove

Count({<$(vSetPeriodRange), [Month of date]=>}Dossier)

Re: Condition not working

sunny_talwar — Thu, 23 Mar 2017 09:35:10 GMT

May be try this:

Sum({<[Month of date]=>}

Aggr(

If(Only({<[Month of date]>} Code_Ligne)='MAR',

(Count({<$(vSetPeriodRange),Code_Ligne={'MAR'}, [Month of date]=,Flag_Doublon={1}>}Dossier)/2) +

Count({<$(vSetPeriodRange),Code_Ligne={'MAR'},[Month of date]=,Timeframe=,Flag_Doublon={0}>}Dossier),

Count({<$(vSetPeriodRange), [Month of date]=>}Dossier)),

Pays, [Month of date]))

Re: Condition not working

zied_ahmed1 — Thu, 23 Mar 2017 09:46:09 GMT

Oh great ,problem resolved

Thank you Sunny

Re: Condition not working

sunny_talwar — Thu, 23 Mar 2017 09:46:49 GMT

It worked?

Re: Condition not working

zied_ahmed1 — Thu, 23 Mar 2017 10:08:07 GMT

Yes Sunny Thank you