Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can't figure out how can I overcome this issue.
I have a variable (Top1) which determines the name of 1 top selling brand: =only({<Brand= {"=rank(sum(Sales), Brand) =1"}>} Brand )
then this value is passed to textbox to get the sales for this top brand: =sum({$<Brand={$(Top1)}>}Sales),
Formula works fine if Brand doesn't have spaces or special characters. Please see the screenshot for the results:
Hello and welcome to the Forums,
I think it's because text in set analysis have to be quoted:
=sum({$<Brand={'$(Top1)'}>}Sales)
Hope that helps
Hello and welcome to the Forums,
I think it's because text in set analysis have to be quoted:
=sum({$<Brand={'$(Top1)'}>}Sales)
Hope that helps
Many thanks, Miguel. It worked.