Set analysis

[Anonymous]

See attached document showing two charts (and list boxes).

This simplified app aims at (with Set analysis) showing the sum of Belopp for respective Kategori as selected in table Val.

Why gives the expression sum({$<Kategori={Val}>}Belopp) with correct syntax "No data to display"?

The expression sum({$<Kategori=Val>}Belopp) with incorrect syntax gives the desired result.

BR, Hans Kaminsky

[sunny_talwar · Accepted solution]

Because you are comparing two fields... you can do this

Sum({$<Kategori=p(Val)>}Belopp)

or

Sum({$<Kategori=Val>}Belopp)

The syntax editor doesn't understand the syntax, but the expression in not incorrect.

[Anonymous]

Thank you! I checked out the p() and e() functions, and they worked just fine! I knew that my expression was ok, but did not like that the text editor red marked the expression showing the syntax as incorrect. But by using the p() function all looks good 🙂