How to add last two rows of two datasets and create new output.

[areeba]

Hi @atcodedog05 ,

I have 2 data sets

Dataset1

Colour   A   B    C

Red       1   2     1

Blue       2   5     2

Total      3    7     3

Dataset2

Colour       A  B    C

Green        2  2     2

Yellow        1  4     8

Total_C      3   6  10

Desired Ouput:

All_colour           A    B    C

Grand_total        6    13  13

idea is to total last two totals together.

Can you help ?

Regards

Areeba

[atcodedog05]

Hi @areeba 

Is it coming like this from the input source ?

[areeba]

@atcodedog05 

i did the operation on

IF [value]>=1000 THEN Round[Value], 1)/1000 ELSE Round([Value], 1) ENDIF

but this one:

it is coming from source as it is , though i applied the same formula on this but this is how it coming .

[atcodedog05]

Hi @areeba 

Try this

IF [value]>=100 THEN Round[Value], 1)/1000 ELSE Round([Value], 1) ENDIF

[areeba]

@atcodedog05 

yeah this worked but thinking where to apply this as i have to show 697 also before these totals also. i have to fix this in All_color(example) workflow somewhere so that it just display direct 6.911

[areeba]

@atcodedog05 

Thank you for guidance, i solved it 🙂

High five 😄

[atcodedog05]

Happy to help and High five 😀✋ @areeba