Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
A table contains products and sales
My script looks like in text object,
Sum({<product={'$(Vproduct)'}>}sales)
It works fine if I enter single product in inputbox.
But now the requirement is
If I enter multiple products in input box then it should display total sales of the respective products.
How to achieve this??
Please suggest!!!
Thanks in advance!
HI,
You can try this.
Sum({<Product = p(Product) >}Sales)
This way you can get the sales of all product without selection and when you make selection it will give for those products.
For multiple values in variable you can try below.
Make sure that values are separated by Comma in variable.
Sum({<Product= {"$(=Replace(vTest,',','","'))"}>}Sales)
Regards,
Kaushik Solanki
HI,
You can try this.
Sum({<Product = p(Product) >}Sales)
This way you can get the sales of all product without selection and when you make selection it will give for those products.
For multiple values in variable you can try below.
Make sure that values are separated by Comma in variable.
Sum({<Product= {"$(=Replace(vTest,',','","'))"}>}Sales)
Regards,
Kaushik Solanki
Hi
Please use =Sum({<Fmonth={'$(=replace(Vproduct,',',chr(39)&','&chr(39)))'}>}sales) when you're entering multiple items( i hope separated by commas).
Regards
Pratyush