Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi I have a problem where the value shown when highlighted an item and showing all is different in the bar chart.
Once filtered, the value is correct
What's the issue. Ill upload the QVF file together !
Try this
Sum(Aggr(IF(Currency = 'THB', SUM(GRAmount)*vThaiRate, SUM(GRAmount)*1), Sub_category, Currency))
Try this
Sum(Aggr(IF(Currency = 'THB', SUM(GRAmount)*vThaiRate, SUM(GRAmount)*1), Sub_category, Currency))
this works, and solved