i have a scenario where i want to do an expression based on a selected value. the user will select zar or gbp in a list box. based on the selection the expression must sum (gbp value) when the user select gbp and sum(zar) when the user select zar. can someone please help me with an expression?
Make a list box with two values zar and gbp. Then create the two expressions, using conditional statements make a statement that uses the Sum(zar) when the value of the listbox = zar and Sum(gbp) when the value of the list box = gbp.
You could make a field with an inline table with the values zar and gbp and then put that field in a list box.
GetFieldSelections(NameOFField) = 'zar' as the conditional (as an example)
