Use the following two expression
val(expression)=IF([val(expression)]>0 AND val1>0,[val(expression)])
val1=IF([val(expression)]>0 AND val1>0,val1)
sumcheck.qvw 136.0 K
Your answer is very helpful. And i need some clarfication.
I have to use the 2 variables in a single field. like comparision selection (one variable), currency (another variable) and the field name is Sales compartion_selection(VBRK.EURKZWI2)
EUR - vCurrency
comparision_selection = vComparision_Selection
VBRK.KZWI2 - Sales value
Now, I need to display the dimension( various dimension ), if the sales value is greater than Zero
how to apply the proper format?