Calculate ConfiForms ValueView based on condition

Markisio December 23, 2022

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 

1 answer

1 accepted

0 votes
Answer accepted
Alex Medved _ConfiForms_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 25, 2022

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 December 26, 2022

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_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
December 26, 2022

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

Like Markisio likes this
Markisio December 26, 2022

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

Suggest an answer

Log in or Sign up to answer
TAGS
AUG Leaders

Atlassian Community Events