Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello
I am trying to do a simple set analysis, but for some reason it is not working as I expected.
I am created a variable called total share
sum(Quantity)
This provides a total... GREAT
but if I change to
Sum({<Wip_Type={'BH'},Report_Display={1}>}Quantity)
No value is displayed
hi Frank,
Is there any chance, there's no record in your data, that fit for the conditions?
G.
G
I double checked and yes there are values in the data for my condition
Frank
Have you checked the syntax of the fields and values is correct in your expression?
If you just do Sum(Quantity) and then using filter panes for Wip_Type and Report_Display to select what you want to filter on, does it give you the desired output?
Also, a good practise now is to use "" instead of ´´ when specifying values in set analysis.
Use a text box for Sum(Quantity) and apply same filter values to see if you getting the output.
May be like this:
Sum({$<Wip_Type={"BH"},Report_Display={1}>}Quantity)
Sum({1<Wip_Type={"BH"},Report_Display=>}Quantity)