Calculate ConfiForms ValueView based on condition

Markisio

is there away to have ValueView to calculate data in TableView based on a condition, here is what I have

 

TableView:

currency, cost

 

ValueView - Field name or expression:

sum:([entry._func.asEntryRef(entry.cost)]) 

 

But I want the sum based on currency if CAD

 

Currency Values are CAD and USD 

 

any help will be much appreciated 

Alex Medved _ConfiForms_

Hi

Not sure the ConfiForms ValueView here would be the best option to use, as it will output something like this

http://recordit.co/GPOGUBf4Hc

But you can definetey use ConfiForms TableViewMerger macro or have mutiple ValueView macros to show amounts for each currency separately (filtered)

Of course you will need to know all possible currencies you want to calculate

http://recordit.co/yCuqBJKLO5

Alex