Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have an issue in getting my formula to Work when using multible values in a variable.
Image 1 is an inputbox with ordernumbers
and my set analysis formula is
=num(sum({1< OrderNumber = {"$(=V_Excluded)"} >} OpenordersAmountDKK) ,'#.##0')
If I only have one value, the formula Works just fine, but I would like it to Work with the possibility of more entries.
Any good ideas out there?
Thx in advance.
Try to use commas instead of semicolons as separator in the input box, then
=num(sum({1< OrderNumber = {$(=V_Excluded)} >} OpenordersAmountDKK) ,'#.##0')
worked like a charm. Thank you very much