cancel
Showing results for 
Search instead for 
Did you mean: 

Sum of a field on Group of different fields

former_member193466
Participant
0 Kudos

Hi,

I have a req to add sum of the fields if the respective fields are more than one, else should pass the same field.

Below is the source structure

From that structure for 13thNov I should populate C filed i.e.value is 1.1, 14thNov should be 1.2, 15th Nov should be 2.2. can you please let me know how can I achieve this based on fields of "a" and "d".

Here  "C" vale is being calculated based on unique of "a" and "d".

Accepted Solutions (1)

Accepted Solutions (1)

former_member184720
Active Contributor
0 Kudos

I saw your requirement in the other thread too. So if i go with that, impliment the logic shown in screenshot.

L1 is A, L2 is D and L3 is your actual value C.  (Ignore that last L1 which should be your target field)

Message was edited by: Hareesh Gampa

former_member193466
Participant
0 Kudos

Thanks alot Hareesh!!

Answers (0)