Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
I have the expression below and would like to understand the where condition (date=,). What is the return when there is nothing in front of the equal sign. also could this expression be written differently?
Sum({$<Date=,[ADDRESS]={HOME},STREET={LEVIS}>} If(Movedate=Date,[Rentpay]))
Thanks for your help.
D
date = means that the expression should ignore any selection in date field. What's the reason to re-write the expression? is this not working or slow? Are you trying to get rid of the if statement?
date = means that the expression should ignore any selection in date field. What's the reason to re-write the expression? is this not working or slow? Are you trying to get rid of the if statement?
Thanks Sunny, Yes the chart is quite slow so I am trying to see if there is a better way of writing the same.
I think you might be looking to remove the if statement. Is movedate and date both fields? Are you able to share a sample to show how the data looks like?
Date and Movedate are not always the same. sorry I don't have a sample data atm. the outcome is on a line chart. Thanks
Dummy data which is close to how your actual data looks