Level 1 model building Part 10: OTH01 Non employee expense module

Hi Team,

I have done as instructed in the training and imported the data from a csv file to the module.

All data gets imported but there is no mapping for the "Total" column in Source to target mapping, which seems to throw result as zero.

PFA pictures for more clarity.

Do I need to use a formula in total column or I am missing something?

OTH01_75566.jpg

OTH01(1)_75566.jpg

Accepted answers

AashcaJ

@kunal_311 Total Column is a sum of all those columns (Hint: you need a formula there). You will not be importing data into the Total column. Makes sense?

All comments

AashcaJ

@kunal_311 Total Column is a sum of all those columns (Hint: you need a formula there). You will not be importing data into the Total column. Makes sense?

JosephA

Need some help in resolving this error after import of non-employee expenses csv. Thanks in advance

Quick Links

Can you help?

Unanswered questions

別ディメンションで、セレクターをモジュールに返し、計算したい
下記のようなことがしたいですコンテキストセレクターの値を別モジュールに反映し、それを使って計算したいです。 selecter A-1 Dim code amount Select→ A-1 1 100 A-2 2 100 A-3 3 100 A-4 4 100 module Dim code amount key Flg A-1 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 1 1 25 A-1 TRUE 2 2 50 A-2 FALSE 2 2 50 A-2 FALSE
Importing Ragged Hierarchies
Hello - I have a 2 level ragged hierarchy (yes, it's a chart of accounts), that for reporting purposes is used in 4 different models (yes, it's a P&L). What is the best way set this to allow one to be the "source of truth" and then import between the four models without creating actions that include ignores? It seems like…
Where can I find export file after running export process using machine task in a workflow?
I am testing export actions using workflow but its not generating any file when I am running the workflow, but the same process is generating export file when ran from the Actions→Process section. Is their any issue with the workflow functionality? Also, If I want to generate a file after completion of workflow and pull…