Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello all,
Need a little help here.
I have to filter my count according to two where conditions :-
1. enddate should be of yesterday (which is running fine)
2. success_value(column) = 100
I am using following expression :-
=count({$<tbl_backup_snapshot.enddate={">=$(=Date(max(tbl_backup_snapshot.enddate), 'DD/MM/YYYY'))"},tbl_backup_snapshot.success_value={'100'}>}[tbl_backup_snapshot.success_value])
But in output, it is showing as 0 here, which is wrong. Kindly help.
Help would be appreciated