My period is august 2018 and the formula returns 1 (Order '300'), which is correct.
Is there a way I can define a flagCreated,
- when selected, the formula remains the same
- when deselected, the formula ignores P() function and returns 2 (Order 100 and order 300)?
The only wat I managed it by creating text variable, which returns P() when selected and returns nothing when deselected, so i subsequently put this varianle into the formula above, but is there a more elegant way?