I have a scenario to be implemented in my queries.
Scenario 1 -
I have a Characteristic field F1.
I have to create a coloum C1 in report display result which populates the below condition:
If F1 = '12345' then C1 = YES
ELSE it should be blank.
I have two date fields D1 and D2 with their corresponding KPI fields DV1 and DV2.
DV1 is for D1 and DV2 is for D2.
First D1 is compared with D2 and whichever is latest date then its corresponding field should be populated and other should not.
Example if D1 is 01.04.2014 and D2 is 22.04.2014 and If DV1 is 100 and DV2 is 200
Then only DV2 should be populated and DV1 should be empty.
Can anyone please suggest?