Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Dears, I would like to do a set analysis using variables, but the variable would be the filter of the formula, for example:
This is the normal
=Sum({$<PRODUCT_FAMILY={"Family"}>}($(vInvoice))
I want to use the variable in the < > (in the place of PRODUCT_FAMILY)
How do I do that?
Yes, see attach
EDIT:
surprising I added the variable inside but it didn't show up
=Sum({$<PRODUCT_FAMILY={"$(vInvoice)"}>}Sales)
=Sum({$<PRODUCT_FAMILY={""}>}Sales)
I would like to place the variable vInvoice inside the < >, instead of PRODUCT_FAMILY
but it is not working properly. How do I do that?
???
and how would it be using the PRODUCT_FAMILY?
Unfortunately no ...
Declare a variable with the value : PRODUCT_FAMILY={"Family"}
Use it in your expression:
=Sum({$<$(vVar)>}($(vInvoice))
You can also use multiple variables:
=Sum({$<$(vVar),$(vVar2)>}($(vInvoice))
Have you tested it?
Yes, see attach
I'm sorry I thought you are asking to have a field value taken from a variable.
but please take a look at the example.
I've declared a variable as Field name and used that in set analysis. I thought it would not work.