Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I would like to make below 2 different expressions to 1. Could you pls let me know how can I do it?
I want to show up the data which is from 2000~5000.
=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))>=2000,sum(if([Notification Date]>ReloadTime()-365, [Cost])))
=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))<5000,sum(if([Notification Date]>ReloadTime()-365, [Cost])))
Thank you very much for your help in advance.
=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))>=2000 and
sum(if([Notification Date]>ReloadTime()-365, [Cost]))<5000,
sum(if([Notification Date]>ReloadTime()-365, [Cost])))
=if(sum(if([Notification Date]>ReloadTime()-365, [Cost]))>=2000 and
sum(if([Notification Date]>ReloadTime()-365, [Cost]))<5000,
sum(if([Notification Date]>ReloadTime()-365, [Cost])))
Thank you so much! Now I know how to do it.