Hi, I am trying to generate every business date for 2023. Then take my data (2 dates) and fill the value for all dates between these 2 dates. So the result would look something like this: Testers2023_10_022022_10_032022_10_04....2023_11_032023_11_04Louis Stevents0.40.40.40.40.40.4 whith 2023-11-04 blank as the .4 doesnt fall in here. Edit - able to get .4 for every business date, but that isnt right. my placeholder formula doesnt seem to be working! cross tab date values.yxmd

2. Add a Record ID Tool (and start the count at an odd number if you need the [Field] value in this row to stay the same OR start the count at an even number if you need the [Field] value in this row to be zero).

3. Add a Formula Tool and use this treatment to update the [Field] value (or create a separate new field)

- Update existing Field

IF Mod([Record ID],2) = 0 THEN 0

ELSE [Field]

ENDIF

- Create a new Field

IF Mod([Record ID],2) = 0 THEN 0

ELSE [the existing that you need to alternate between zero and itself]

ENDIF

I hope you find this helpful - cheers!

Quick Links

This months top contributors

atcodedog05 19598

Qiu 15881

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703