Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I am using the formula =Sum({$<Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))},Years=,Months= >}Sales)
and i am getting the overall sales value for all SKU.
i want sales value for one SKU to be displayed without selecting a particular SKU.
Anyone help me.
Thanks in Advance
Regards,
Joshua.
May be this?
=
If(GetSelectedCount(SKU)>0,
Sum({$<Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales) ,
Sum({$< SKU ={SKUValue1},Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales)
)
Assuming SKU is a field here. Try like:
=Sum({$< SKU={SKUValue1},Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))},Years=,Months= >}Sales)
Why are you specifying Years and Months twice in your set analysis?
But at the same time end user should view other SKU sales also.How it can be achieved?
If i didnt specify twice the values are not changing during year selection in listbox.
thank u
If you want users' selection+one specific SKU, then try with '+' like:
=Sum({$< SKU +={SKUValue1},Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales)
Omit the Years=, Months= combo then. They actually serve to clear all selections for this sum, which is not what you intend to do.
The other specifications Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))} will select the highest currently selected value from both listboxes, whether you actively select some (green selections) or non (all white).
BTW tres has your solution.
Thank u sir.
Peter if i use SKU this formula a particular SKU is hardcoded but i want the values to be changed when the user selects different SKU also
=Sum({$< SKU +={SKUValue1},Years = {$(=max(Years))},MonthID1={$(=Max(MonthID1))}>}Sales)