Importing fata

Rohs98
Occasional Contributor

Importing fata

I'm unable to upload data for utilities and total line item plz help. Screenshot (13).pngScreenshot (14).pngScreenshot (15).pngScreenshot (16).pngScreenshot (17).pngScreenshot (12).png

1 ACCEPTED SOLUTION

Accepted Solutions
Rohs98
Occasional Contributor

Hey Hi Ankit thanks got that, can you help me with the formula for total  ?

View solution in original post

3 REPLIES 3
ankit_cheeni
Super Contributor

You have misspelled Utilities in target module which is why it is not mapping by default. Either correct the spelling or map it manually (Map items manually on top left). 

You don't have a total line item in your source so which column do you want to map it to? Are you sure you want to import into total? It could also be formula driven 🙂

Rohs98
Occasional Contributor

Hey Hi Ankit thanks got that, can you help me with the formula for total  ?

ashubham
Occasional Contributor

If the requirement is very simple.

 

It should be simply: <Shipping Costs + Rent + Utilities + Shared Costs>

 

While if the total is required to be on a specific list summary, You can lookup the parent or create a line item for the base of the lookup.