Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I can't seem to get the result of my FirstSortedValue function to work in Set Analysis.
If I have a variable:
vTestDeal = FirstSortedValue(KeyDeal, Proceeds)
...which yields 10 and a set analysis expression:
Sum({$<KeyDeal = {$(vTestDeal)} Measure)
then you would think that I would get the Sum of the Measure where KeyDeal = 10. However, the chart doesn't calculate and I get a "No data to display" error.
If I replace $(vTestDeal) in the set analysis with the number 10, my data comes up correctly. This made me think it might be a datatype issue or something, but experimenting with num and text functions and using single quotes didn't solve my issue.
Anyone have any ideas?!
Thanks,
Scott
Scott can you try with:
Sum({$<KeyDeal = {"$(vTestDeal)"} Measure)
Regards,
Kiran.
Scott can you try with:
Sum({$<KeyDeal = {"$(vTestDeal)"} Measure)
Regards,
Kiran.
use beelow code
Sum({$<KeyDeal = {"$(vTestDeal)"} <}Measure)
as KeyDeal returns numeric value then to compare it with vTestDeal you have to convert it into numeric:
Sum({$<KeyDeal = {$num#(vTestDeal)} Measure)
try it.
regards
Thanks everyone, I was able to wrap my variable in a num function and use the doubel quotes to get my answer.