Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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))
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,
May be this will work
sum({<[Cust Group] =>,<[Module] => } if(MonthIndex >= ( vMaxMonthIndex -1) and Branch='Johannesburg' ,
[Order Quantity Backordered]*
[Component Qty],0))
Hi Sujeet
Thanks. However it does not work. As soon as you type the comma after => , the red underline appears.
kind regards
Nayan
can you give a sample
?
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
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,
Try this
sum({<[Cust Group] =, [Module]=> } if(MonthIndex >= ( vMaxMonthIndex -1) and Branch='Johannesburg' ,
[Order Quantity Backordered]*
[Component Qty],0))
Hi Sujeet
Thank you . It worked. Much appreciated.
kind regards
Nayan
Hi Mohit
Thank you. Thats the formula i used. It worked
kind regards
Nayan
if t helps you then mark it so it might be helpful for those developer which are using personal edition and others too