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_ · Accepted solution]

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

[Markisio]

thanks @Alex Medved _ConfiForms_ 

I like this: http://recordit.co/yCuqBJKLO5 wondering if I have multiple filters how I can configure that? I tried AND, & and comma nothing works :) 

thanks 

[Alex Medved _ConfiForms_]

Nothing works… how many times I have heard this…

have a look at the documentation on filters https://wiki.vertuna.com/display/CONFIFORMS/ConfiForms+Filters

[Markisio]

Thanks works, I prob did small letter and :) thanks a lot!