Straight Table not affected by more than one selection

[#1]

Hi

I have a formula below that works, where its not affected by [Cust Group] selection.

I now want to add to this formula that will also not be affected by [Module] selection.

How do i add this to the formaula.

kind regards

Nayan

sum({<[Cust Group] => } if(MonthIndex >= ( vMaxMonthIndex -1)  and Branch='Johannesburg' ,

[Order Quantity Backordered]*

[Component Qty],0))

[sujeetsingh]

May be this will work

sum({<[Cust Group] =>,<[Module] => } if(MonthIndex >= ( vMaxMonthIndex -1)  and Branch='Johannesburg' ,

[Order Quantity Backordered]*

[Component Qty],0))

[#3]

Hi Sujeet

Thanks.  However it does not work.  As soon as you type the comma after => , the red underline appears.

kind regards

Nayan

[sujeetsingh]

can you give a sample

?

[#5]

Hi Sujeet

In my [Module] list box , there are 2 variables .  Order Entry  and Acc.Receiv .  (see below list box)

So , when I select Order Entry, it should not affect my value above.

I know its not a sample, but will this help.

kind regards

Nayan

[sujeetsingh · Accepted solution]

Seee this sample here i have not used the same expression but yes made the expression as not to have any affect from selection in Module  and CustGroup.

Hope it help,

[er_mohit]

Try this

sum({<[Cust Group] =, [Module]=> } if(MonthIndex >= ( vMaxMonthIndex -1)  and Branch='Johannesburg' ,

[Order Quantity Backordered]*

[Component Qty],0))

[#8]

Hi Sujeet

Thank you .  It worked.  Much appreciated.

kind regards

Nayan

[#9]

Hi Mohit

Thank you.  Thats the formula i used.  It worked

kind regards

Nayan

[er_mohit]

if t helps you then mark it so it might be helpful for those developer which are using personal edition and others too