Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Need logic to find sheet 2 Date given in below sample data
could you be more specific
something like
if([Sheet 1 Date]-[Sheet 2 Date]=5,[Sheet 2 Date],null()) ????
regards
Pradosh
could you be more specific
something like
if([Sheet 1 Date]-[Sheet 2 Date]=5,[Sheet 2 Date],null()) ????
regards
Pradosh
Day-5 would give you 5 days back.
In script use
day([Sheet 1 Date]) as Sheet1Day,
day([Sheet 2 Date]) as Sheet2Day,
In expression use
sum({<Sheet1Day= {$(=(Sheet1Day)-5)}>}(Sheet1Day))
Not sure if the expression is correct but it would give me the values against day selected.