Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
how to create a list box with two values by writting an expression instead of taking system fields?
Hi 3,
Find the attacment.Let me know if you have any issue
Thanks & Regards
Jai
heiio jai,
actually we have to create a calculated dimension in that list box.in our database there are 2 diff. fields namely "Invoice Quantity" and "Contract Quantity" in two diff. tables.we want to show the calculated dimension (Contract Quantity - sum(Invoice Quantity) ) as "Contract Status" so that it can work on individual item seperately.and we also want to asign two values in the list box "Contract Status" namely "PENDING"(if "Contract Status">0) else "COMPLETED".